oracle分页查询sql

 select * from( select shopid,rownum rn from p_shopinfo where is_hot=1 and rownum <=6 order by shopid desc) where rn>3