查询scott用户的emp表按薪水从高到低排序,列出第五位到第八位员工的姓名、薪水和职位。
select rownum,ename,sal,job from (select * from emp order by sal desc) where rownum < 9
minus
select rownum,ename,sal,job from (select * from emp order by sal desc) where rownum < 5;
查询scott用户的emp表按薪水从高到低排序,列出第五位到第八位员工的姓名、薪水和职位。
select rownum,ename,sal,job from (select * from emp order by sal desc) where rownum < 9
minus
select rownum,ename,sal,job from (select * from emp order by sal desc) where rownum < 5;