INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Keep Max value from a unqiue fields

Keep Max value from a unqiue fields

(OP)
Basicly this is the problem.
I have one value that can have multiples and have a quanity attached to it. I want to return that value once and get the highest quanity. (ie. NAME, ORDER QUANITY - Joe 5, Joe 15 Joe 12 it would return Joe 15)

Thanks
For your help!

RE: Keep Max value from a unqiue fields

select NAME
 , max(ORDER_QTY)
from MyTable
group by NAME


RE: Keep Max value from a unqiue fields

Perhaps did you need something else in your record, such as an ORDER_ID for example.
Try this :

CODE

select    A.NAME
    ,    A.ORDER_ID
    ,    A.ORDER_QTY
from    MyTable    as A
where    exists (    select    1
                    from    MyTable as B
                    where    A.NAME = B.NAME
                    having    A.ORDER_QTY = max(B.ORDER_QTY)
                )
;

RE: Keep Max value from a unqiue fields

(OP)
Thanks thats just what I need I don't know why I didn't think of it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close