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
cailijuan 2019-09-04 15:24 原文
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