Oracle 分页的三种方式

Posted on 2017-04-11 Edited on 2025-07-25 In Tech Symbols count in article: 260 Reading time ≈ 1 mins.

第一种：

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;

Post author: hisenyuan
Post link: http://hisen.me/20170411-Oracle分页的三种方式/
Copyright Notice: All articles in this blog are licensed under BY-NC-SA unless stating additionally.