Friday, August 27, 2010

Nth Salary in Sql server 2005

SELECT TOP 1 salary


FROM (

SELECT DISTINCT TOP n salary

FROM TableName
ORDER BY salary DESC) a

ORDER BY salary

No comments:

Post a Comment