摘要： select * from( select shopid,rownum rn from p_shopinfo where is_hot=1 and rownum <=6 order by shopid desc) where rn>3 阅读全文