Monday, 24 August 2015

How to find second highest salary in SQL using TOP?


Table Name : SalaryDetails

IDSalary
11000
2500
3750
4500
5350
6750

SELECT TOP 1 salary FROM
(
             SELECT DISTINCT TOP 2 salary FROM SalaryDetails ORDER BY salary DESC
) a
ORDER BY salary asc

No comments:

Post a Comment