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;
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;