sql分页写法

方法一：

select * from (select A.*,rownum RN from t_order_item  A where  rownum <= 20 order by orderid)  where RN >10;

方法二：

select * from (
select row_number() over(order by orderid) rn,t.* from t_order_item t)
 where rn>11 and rn<=20