SQL > select rownum,empno,ename,job,sal from
(select rownum,empno,ename,job,sal from emp
order by sal desc )
where rownum <= 5;
(select rownum,empno,ename,job,sal from emp
order by sal desc )
where rownum <= 5;
Showing posts with label Retrieving Top 5 Highly paid Employees. Show all posts
Showing posts with label Retrieving Top 5 Highly paid Employees. Show all posts
Wednesday, 7 May 2014
Subscribe to:
Posts (Atom)