Monday, 26 October 2015

How to find second highest salary using Ranking Function (DENSE_RANK()) in SQL?


Table Name : SalaryDetails

IDSalary
11000
2500
3750
4500
5350
6750

SELECT a.Name,a.salary
FROM  (   SELECT Name,salary,DENSE_RANK() over (ORDER BY salary desc) AS Rank FROM salaryDetails  )  as a where Rank = 2 

No comments:

Post a Comment