> 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.

try,

SELECT FIRST 1 Number from Table Order By Amount Desc


Sean