SQL Command Of WIPRO

1. Find the third largest amount from Order table;

SELECT * from(select *,DENSE_RANK() over (order by amount desc) as dense_rank from Orders) where dense_rank = 2;