Monday, November 9, 2009
How to find nth highest salary from Employee table in SQL Server?
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY salary
Subscribe to:
Post Comments (Atom)
Search SQL Academy
Search This Blog
AddThis
Categories
- Columns (1)
- Interview Questions (4)
- Query Performence (1)
- Triggers (1)
0 comments:
Post a Comment