Microsoft Techies: Oracle Retrieving Top 5 Highly paid Employees

Showing posts with label Oracle Retrieving Top 5 Highly paid Employees. Show all posts

Friday, 9 May 2014

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