Find 3rd Maximum Value In SQL

 

(Note:tb-tablename,amount-column name)

SELECT MIN(amount) FROM tb WHERE amount IN
(SELECT distinct TOP 3 amount FROM tb ORDER BY amount desc)