interview help in Oracle
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment