其中红色的为正常sql执行语句,黑色的为分页语句执行的框架
select * from (
select row_number()over(order by CreateTime)rownumber,* from (select
*
FROM
表
WHERE
Code = #{Code,jdbcType=VARCHAR}
And Name = #{name,jdbcType=VARCHAR}
And EnglishtName = #{englishName,jdbcType=VARCHAR}
) b
)a WHERE rownumber>0 and rownumber<5;
======================================================================
其中规范的格式是:
select * from (
select row_number()over(order by PId desc) as rownumber,b.* from (正常的查询处理
) b
)a WHERE rownumber >0 AND rownumber <10;
============================================================
这个是在mapper.xml中区别 ‘<’、'>' 号常用的
<![CDATA[ rownumber >= #{start} and rownumber <= #{end} ]]>;