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);