I have a table like

Number Key Value
1 10 A
2 12 B
2 13 C
3 14 D

I need a sql statement to get Value where Key is max for a given
number.
i.e. I pass 2 to query and I want result C


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz