Rajeeva Tripathi
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment