分页

 select  /*+first_rows*/
         cid,pid,cname,cnt,rn
      from
      (select t.* ,row_number() over(order by t.cid desc) rn
        from tb_jff t
        )
  where  rn <=3* 2
       and rn >(2-1)*3;