Oracle高效分页语句
with t_rowtableas( 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 field1select * from table_name limit 21,40 select * from ( select A.*,rownum rn from (select * from Table_name) A where rownum <=40) where rn>=21
