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)

Contact

M. Jeyachandran @ M.Jayaramchandran 9840923422 jayaramchandran.m@gmail.com