Oracle分页语句

 

  page size :3

  page number: 2

  需要考虑order by 的情况：

  select s.* from
  ( 
     select rownum as rn,c.*
     from (select * from tableName order by columnName desc) c
  ) s
  where s.rn between 3*(2-1)+1 and 2*3;

  
   select * from
   (
      select rownum as rn,c.*
      from (select * from tableName order by columnName asc) c
      where rownum<2*3+1
   ) s
   where s.rn>3*(2-1);