Wednesday 7 May 2014

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;