oracle分页

每页10条，第2页

select f2.*
  from (select f1.*,ROWNUM RN
          from (select t.* from jhmmm_qualifi_result t order by t.id desc) f1
         where rownum <=  10 * 2) f2
 where f2.RN >=  (2 – 1) * 10 + 1

select *
  from (select t.*, ROW_NUMBER() over(order by id desc) rn
          from jhmmm_qualifi_result t) f1
 where f1.rn between (2 – 1) * 10 + 1 and 10 * 2