详解oracle分页查询的基础原理

CREATE TABLE TEST(
ID NUMBER,
NAME VARCHAR2(20)
)

INSERT INTO TEST VALUES (1,'张三');
INSERT INTO TEST VALUES (2,'李四');
INSERT INTO TEST VALUES (3,'王五');
INSERT INTO TEST VALUES (4,'赵六');
INSERT INTO TEST VALUES (5,'郑七');
INSERT INTO TEST VALUES (6,'胡八');
INSERT INTO TEST VALUES (7,'刘九');

select rowid,rownum,id,name from TEST;

select rowid,rownum,id,name from test where rownum <5;

select rownum,id,name from test where rownum>2 and rownum <5;

select rownum,id,name from
( select rownum rn, u.* from test u where rownum<5) un
where un.rn>2

select rownum,id,name from (
  select rownum rn , t.* from test t where rownum <=6) n
where n.rn>=4

select rownum,id,name from (
  select rownum rn, n.* from 
    (
     select * from test --最内层循环该怎么写怎么写
    ) n where rownum <=6 --小于限制写在第二层
  ) 
 where rn>=4