Second highest salary

Sonakshi Singh

14y2.8k

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
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<=B.salary)

Thanks
0
Sonakshi Singh14y ago
O thank you so much all of you for helping me...
0
Prabhu Raja14y ago
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
0
Jignesh Trivedi14y ago
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.
0

Dhaval Patel14y ago

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 <= r2.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