How to find the third heighest salary of emp table?

Question

Hi In the emp table we want third heighest salary in this table by sql command

Satyapriya Nayak · Answer

Hi Abhishek select distinct(salary) from employee A where 3=(select count(distinct(salary)) from employee B where A.salary Thanks

Mukesh Kumar · Answer

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

Dhaval Patel · Answer

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