Saturday, October 31, 2009

Sql Server - 4th highest salary from Emp table

The 4th highest salary from Emp table -Sql server

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 4 salary
FROM emp
ORDER BY salary DESC) a
ORDER BY salary

The nth highest salary from Emp table as follows

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM emp
ORDER BY salary DESC) a
ORDER BY salary

Other
=====
SELECT MIN (SALARY )
FROM EMP
WHERE SALARY IN
(SELECT DISTINCT TOP 4 SALARY
FROM EMP
ORDER BY SALARY DESC)

No comments: