Oracle没有mysql像limit的语法,所以写法比较蛋疼select T1.*,RN FROM( select rownum rn,T.* FROM( select * from mall_shop ms ) T where rownum <![CDATA[&