The query should be
select * from employee
where salary in
(select salary
from employee
order by salary desc)
and rownum <= 5
|
Results 1 to 10 of 11
Thread: Fine tuning SQL queryThreaded View
|
Click Here to Expand Forum to Full Width |