简单的SQL命令分页的方法大概有以下两种:
1:使用with pardata指令结合rownum来完成,示例如下:
with partdata as (select rownum rowno,t.* from testtable t) select * from partdata where rowno between 1 and 100
2:使用rownum,结合子查询的方法,示例如下:
select f01,f02,f03 from (select rownum rowno,f01,f02,f03 from testtable where rownum <=100) where rowno>=1;
备注:以上方法也适合在多表联合的情况下
1:使用with pardata指令结合rownum来完成,示例如下:
with partdata as (select rownum rowno,t.* from testtable t) select * from partdata where rowno between 1 and 100
2:使用rownum,结合子查询的方法,示例如下:
select f01,f02,f03 from (select rownum rowno,f01,f02,f03 from testtable where rownum <=100) where rowno>=1;
备注:以上方法也适合在多表联合的情况下