Getting nth highest/lowest salary

Getting nth highest salary

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


Getting nth lowestsalary

SELECT max(Sal) FROM TableName
WHERE Sal IN
(SELECT DISTINCT TOP N Sal FROM TableName ORDER BY Sal)