How to find the third heighest salary of emp table?

Hi Abhishek,


select distinct(salary)  from employee A where 3=(select count(distinct(salary)) from employee B where A.salary<=B.salary)




Thanks

Hi ,

Try this

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Dear Abhishek

refer below link

http://www.c-sharpcorner.com/Blogs/7111/how-to-get-second-highest-and-lowest-record-in-sql-server.aspx

use this query

SELECT  Temp_id from TblTemp c1
WHERE 3=(SELECT count(*) from TblTemp c2
WHERE C1.Temp_id >= C2.Temp_id )

Thanks
Dhaval Patel

This post help you than Mark As Accepted Answer