mysql分页和oracle分页
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
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
