oracle的分页查询:
sql>select t2.* from
(select t1.* ,rownum rn from
(select * from emp) t1 where rownum<=6) t2 where rn>=4;
6--> 表示取到第几条
4-->表示从第几条开始取
因为oracle内部有优化!
对于这种语句:
select emp.* ,rownum from emp where rownum>=4 and rownum<=6;
查询不出结果!!!
sql>select t2.* from
(select t1.* ,rownum rn from
(select * from emp) t1 where rownum<=6) t2 where rn>=4;
6--> 表示取到第几条
4-->表示从第几条开始取
因为oracle内部有优化!
对于这种语句:
select emp.* ,rownum from emp where rownum>=4 and rownum<=6;
查询不出结果!!!