分页查询 【理解rownum的含义】
查询员工姓名 工资 部门编号前5条
select ename,sal,deptno from emp where rownum <= 5;
查询员工姓名 工资 部门编号 6至10条数据
select * from (select ename,sal deptno,rownum as rw from emp) where rw>5 and rw<=10;
每页显示三名员工的信息,并按照工资降序排列
select * from (select ename, sal, rownum as rw1 from (select ename, sal, rownum as rw from emp order by sal desc) ) where rw1 > 0 and rw1 <= 3;