select * from (
select A.*,ROWNUM RN from (
select * from table_name
) A where ROWNUM <= page*pageSize
) B where RN > (page-1)*pageSize
page是第几页,pageSize是每页多少行;比如查询第8页,每页10行,结果是10条;
DB2
select * from(
select b.*, rownumber() over() as rn from (
select * from table_name
) as b
) as a where a.rn between startnum and endnum;
startnum是起始的位置号,endnum是结束位置号,比如between8,10查询第8位到第10位,结果是3条(8、9、10);
Mysql
select * from table_name limit startnum,pageSize
startnum是起始的位置号(不包含),pageSize是每页多少行,比如limit 2,3表示查询从第3位开始查3条(3、4、5);