Top N Analysis
select last_name, salary from
(select d.last_name, d.salary from employees d order by 2 desc)
where rownum < 5
Top N Analysis reverce
select last_name, salary from
(select d.last_name, d.salary from employees d order by 2 )
where rownum < 5
order by 2 asc
No comments:
Post a Comment