数据库分页

--oracle分页 方法1(根据ROWID来分)
select *
  from uop_crm1.tf_f_user
 where rowid in
       (select rid
           from (select rownum r, rid
                   from (SELECT rowid rid from uop_crm1.tf_f_user u)
                  where rownum < 150)
          where r > 100)

   
--方法2(按分析函数来分)
select *
  from (SELECT n.*, row_number() over(order by net_type_code) rk
          from uop_crm1.td_s_netcode n)
 where rk > 5
   and rk < 10

--方法3（按ROWNUM来分）
select *
  from (select u.*, rownum rn
          from (SELECT * FROM uop_crm1.tf_f_user) u
         where rownum < 1000)
 where rn > 900