select Value from aTable where Key = (select max(Key) from aTable where
Number = ? )

-----Original Message-----
From: Sandeep [mailto:sandeep@...]
Sent: Monday, April 08, 2002 9:06 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] SQL


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




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/