1.DB2数据库的分页:
select * from (select a.*,rownumber() over() as rowid from (select * from tbl_net_order) a) tmp where tmp.rowid >=#{startIndex} and
tmp.rowid <= #{endIndex};
-------------------------------------
2.mysql分页:
select * from table limit start,pageNum
---------------------------------------------------
3.oracle数据库分页:
select * from (select rownum row_num,month,sell from (select month,sell from sale group by month,sell)) where row_num between 5 and
9;
-------------------------------------------------------