A blog to learn .Net coding basics and various topics related to this.
Thursday, 30 April 2015
SQL :- How to find nth highest salary
SELECT * /*This is the outer query part */
FROM Employee Emp1
WHERE (N-1) = ( /* Subquery starts here */
SELECT COUNT(DISTINCT(Emp2.Salary))
FROM Employee Emp2
WHERE Emp2.Salary > Emp1.Salary)
No comments:
Post a Comment