Wednesday, September 1, 2010

How can I get 5th highest sal. from employee tab?

SELECT employee_id
, salary
FROM (SELECT employee_id
, salary
, dense_rank() over (order by salary desc) poradi -- 5th value
--, row_number() over (order by salary desc) poradi -- 5th row
FROM employees)
WHERE poradi = 5;

No comments:

Post a Comment