| Re: how to retrieve top 3 salaries [message #20032] |
Thu, 25 April 2002 11:42 |
Alex Mazur
Messages: 17
Registered: March 2002
|
Junior Member |
|
|
I'd rather not to rely on ORDER BY in subqueries.
I had very bad experience when Oracle did not sort
data returned by subselect and i got incorrect data.
If you have Oracle 8.1.6 and later the best way how
to get top 3 paid employees for my oppinion is:
select * from
( select employee_id, salary,
rank() over ( order by salary desc ) rk
from employees
)
where rk <= 3
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
