Second highest salary

Question

How can i find out second highest salary in particular database?

Satyapriya Nayak · Answer

Hi Sonakshi For 2nd highest salary Here n=2 select distinct(salary) from employee A where 2 =(select count(distinct(salary)) from employee B where A.salary Thanks

Sonakshi Singh · Answer

O thank you so much all of you for helping me...

Prabhu Raja · Answer

Hi Sona Try this out  Hope it will help you. DECLARE @N Int SET @N = 2 SELECT * FROM Employee E1 WHERE (N-1) = ( SELECT COUNT(DISTINCT(E2.Salary)) FROM Employee E2 WHERE E2.Salary > E1.Salary) If this post helps you then mark as Correct Answer. Thank You

Jignesh Trivedi · Answer

hi try this select * from( SELECT empId salary ROW_NUMBER()OVER(PARTITION BY salary ORDER BY salary desc ) as RowNum from ExaminationOptions) A where A.RowNum =n using the above query u can find n number of highest salary. hope this help.

Dhaval Patel · Answer

Dear sonakshi please use this query 2nd Highest record ------------------------------------------------- SELECT * FROM TblTemp WHERE Temp_id = (SELECT min(Temp_id) FROM TblTemp WHERE Temp_id > (SELECT min(Temp_id) FROM TblTemp)) 2nd highest record ----------------------------------------------- select Temp_id from TblTemp r1 where 2=(select count(*) from TblTemp r2 where r1.Temp_id please refer this blog for more information http://www.c-sharpcorner.com/Blogs/7111/how-to-get-second-highest-and-lowest-record-in-sql-server.aspx