Monday 15 October 2012

How to find out n th salary from a Table

SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP n Sal FROM TableName ORDER BY Sal DESC)

No comments:

Post a Comment