Friday, 9 May 2014

Oracle Retrieving Top 5 Highly paid Employees


SQL > select rownum,empno,ename,job,sal from
(select rownum,empno,ename,job,sal from emp
order by sal desc )
where rownum <= 5;