For particular example of employee :
How to get 1st, 2nd, 3rd, 4th, nth topmost salary from an Employee table
The following solution is for getting 6th highest salary from Employee table ,SELECT TOP 1 salaryFROM (SELECT DISTINCT TOP 6 salaryFROM employeeORDER BY salary DESC) aORDER BY salaryYou can change and use it for getting nth highest salary from Employee table as follows
SELECT TOP 1 salaryFROM (SELECT DISTINCT TOP n salaryFROM employeeORDER BY salary DESC) aORDER BY salarywhere n > 1 (n is always greater than one)
No comments:
Post a Comment