Oracle 分页模板
select * from (
select t.*, rownum as rowno from
(
--- 放需要分页的sql
) t where rownum <=20) a where a.rowno >=1
Oracle 分页模板
select * from (
select t.*, rownum as rowno from
(
--- 放需要分页的sql
) t where rownum <=20) a where a.rowno >=1