关于oracle分页

 

 

１.根据rownum来分

 

select t2.* from (select t1.*, rownum rn from (select * from emp) t1 where rownum <= 4) t2  where rn >= 2

 

先说一下rownum理解ORACLE系统为查询结果分配的一个顺序编号，比如第一行为1，第二行为2，第三行为3，依此类推。

但查询的时候，你不能写成rownum > 2

http://www.cnblogs.com/zjrstar/archive/2006/08/31/491090.html

 

２.根据分析函数来分

 

select t2.* from (select t1.* ,row_number() over(order by empno) as numindex from emp t1) t2 where numindex between 2 and 4

 

 

３.根据rowid来分

 

select t4.* from emp t4 where rowid in 
(select rid from (select rid,rownum rn from (select rowid rid from emp) where rownum <=4)  where rn >=2) order by t4.empno