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