How to get max value within same id

jackps · January 20th, 2004, 07:19 AM

Dear all
I had a table which contain user_id and expenses_amount.what sql i should use to pick up the most largest value in expenses_amount with a same id.
Here is an example :

     User_id Exp_amt
     102111 5000
     102111 600
     102111 7800

then the bingo record = 102111 7800

Thx alot
Jack

chrislepingwell · January 20th, 2004, 07:26 AM

Well, you could use

Code:

Select User_ID, Max(Exp_amt)
From YourTable
Where User_ID = 'insert reqd id here'

Or if you want every user listed

Code:

Select User_ID, Max(Exp_amt)
From YourTable
Group By User_ID
Order By User_ID desc

HTH

There are two secrets to success in this world:
1. Never tell everything you know