Advertisement
SMASIF

Find Nth Highest Salary

Nov 3rd, 2020
2,003
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.15 KB | None | 0 0
  1. SELECT MIN( Amount )
  2.   FROM EmployeeSalaryDetail  
  3. WHERE  Amount IN (SELECT DISTINCT TOP N Amount FROM EmployeeSalaryDetail ORDER BY Amount DESC)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement