HiSEN

hisenyuan's Blog

0%

Oracle 分页的三种方式

Posted on Edited on In Symbols count in article: 260 Reading time ≈ 1 mins.

第一种：

1
2
3
4
5
select *
  from (select t.*, rownum rn
          from (select * from EW_AUTH_FLOW) t
         where rownum <= 5)
 where rn > 2;

第二种：

1
2
3
select *
  from (select t.*, rownum rn from ew_auth_flow t where rownum <= 5)
 where rn > 2;

第三种：

1
2
3
select *
  from (select t.*, rownum rn from ew_auth_flow t)
 where rn between 2 and 5;
Related Posts