SQL to generate top three transaction on the basis of amount?

Vote count:

-1

I have a transaction(id, quantity, rate, stock_code, user_code) table and I want to generate the top three transactions on the basis of their amount in descending order. Amount = quantity * rate

Is there a way to generate using only sql ?

asked 54 secs ago

user3127109

31

SQL to generate top three transaction on the basis of amount?