Oracle answer.
Re: how to find out the 4th highest value from the column?
[sql]
SELECT ROWNUM AS RANK,D.SALARY
FROM (SELECT MAX(SALARY) AS SALARY
FROM EMPLOYEES
ORDER BY SALARY DESC) D
WHERE ROWNUM<=4
MINUS
SELECT ROWNUM AS RANK,D.SALARY
FROM (SELECT MAX(SALARY) AS SALARY
FROM EMPLOYEES
ORDER BY SALARY DESC) D
WHERE ROWNUM<=3
[/sql]
|