Friday, October 23, 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

Share This!


Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
Powered By Blogger · Designed By Seo Blogger Templates