Monday, December 1, 2008

Find Top second salary in sql

Hi,
Here is the query to find the 1,2,3,4.. nth highest salary

Select Top 1 salary from (select Distinct top 3 salary from Employee Order By Salary desc) as a order by salary asc
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)