select * from (select rownum,name from user_tables where rownum <= endIndex)
where rownum > startIndex
如果加了order就更麻烦了
select * from (select rownum,name from user_tables order by orderstr) where rownum <= endIndex
and rownum > startIndex
Mysql最简单 limit
select * from table where whereclause order by orderstr limit start,pageNum
DB2 使用rownumber over和fetch first rows only
select * from (select syscat.indexes.*, rownumber() over() rownum from syscat.indexes where owner='DB2INST1' order by indname desc fetch first 100 rows only) where rownum < 20 and rownum >= 15