Help with Distinct Query 1

[JazzMaan]

I have the following scenario

store_id , amount
1, 20
1, 33
2, 39
3, 31

I would like to get the distinct records containg the store_id and the max amount.


I have tried:
select store_id, max(amount)
from store
group by store_id, amount

 

[gmmastros]

Close. Try this.

select store_id, max(amount)
from store
group by store_id

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom