oracle 常用分页

--oracle 常用简单分页
--方法1.
select soo.code, soo.id
  from (select rownum as rn, tso.id, tso.code
          from t_so_sales_order tso
         where rownum <= 10
         order by id asc) soo
 where soo.rn >= 1
--方法二
select tso2.code, tso2.id
  from t_so_sales_order tso2
 where rownum between 1 and 10
 order by id asc