Hi,

Select number from tablename where amount=(select max(amount) from
tablename).

This will give 3.

Sivaraman


At 11:02 AM 18/12/2002 +0000, you wrote:

>Hi
>
>I want to get the Number for the record for which amount value is max.
>
>I have following records in my table
>
>Number Amount
>1 10.89
>2 12.90
>3 22.78
>4 7.77
>
>how do I get 3 using a sql statement.
>
>Regards
>
>Sandeep
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.