SELECT TOP 1 salary FROM (SELECT DISTINCT TOP n salary FROM employee ORDER BY salary DESC) a ORDER BY salary
How to find nth highest salary from Employee table in SQL Server?
Posted by
Rajesh Rolen
at
Friday, October 23, 2009
Labels: SQL , SQL Interview Questions , sqlserver
0 comments:
Post a Comment