select * from
(select rownum r, a.* from
(select * from table_name by 主键
) a
where rownum < currentPage * pageSize
)
where r > (currentPage - 1) * pageSize
(select rownum r, a.* from
(select * from table_name by 主键
) a
where rownum < currentPage * pageSize
)
where r > (currentPage - 1) * pageSize