Have a look at the below table:
Item Value
A 10
b 50
c 90
I want to find the item with maximum value
. I can get that by using group by
or orderding
, but somehow I have a feeling there should be a more direct way. Am I right?