oracle 常用分页语句

select * from (
select rownum rn,r.* from system_resource r where rownum<=20
)
where rn>=2