Oracle高效分页语句

with t_rowtable
as
(
    select row_number() over(order by field1) as row_number,* from t_table
)
select * from t_rowtable where row_number>1 and row_number < 4 order by field1
select * from table_name limit 21,40 
select * from ( select A.*,rownum rn from (select * from Table_name) A where rownum <=40) where rn>=21