Oracle没有mysql像
limit
的语法,所以分页写法相当蛋疼
select T1.*,RN FROM(
select rownum rn,T.* FROM(
select * from mall_shop ms
) T where rownum <![CDATA[<=]]> (#{page}*#{size})
) T1 where RN <![CDATA[>=]]> (#{page}-1)*10
Oracle没有mysql像
limit
的语法,所以分页写法相当蛋疼
select T1.*,RN FROM(
select rownum rn,T.* FROM(
select * from mall_shop ms
) T where rownum <![CDATA[<=]]> (#{page}*#{size})
) T1 where RN <![CDATA[>=]]> (#{page}-1)*10