正文oracle分页查询sqlIP云V管理员/2022-09-04/0 阅读 09/04小程序:扫一扫查出行【扫一扫了解最新限行尾号】复制小程序 select * from( select shopid,rownum rn from p_shopinfo where is_hot=1 and rownum <=6 order by shopid desc) where rn>3