How to get 3rd, 5th or 6th i.e. N'th highest Salary?


SELECT * FROM EMPLOYEE E   
WHERE 2 = (SELECT COUNT(DISTINCT E1.SALARY)   
FROM EMPLOYEE E1   
WHERE E1.SALARY>E.SALARY)


Here, 2= 3-1 i.e. N-1 ; can be applied for any number.




Post a Comment

0 Comments