1,mysql分页
select * from table_test LIMIT ((pageNum - 1) * pageSize),pageSize)
2,oracle分页
select * from (select ROWNUM as rowno, tt.* from table_test tt) a where a.rowno between ((pageNum -1)*pageSize + 1) and pageNum*pageSize
原文：https://www.cnblogs.com/cailijuan/p/11459383.html