#在使用xml映写sol查询语句时发现order排序和limit分页不能连用,会将limit识别成一个未知数据库报错,正确的语句该如何书写呢
select * from emp
<where>
<if test="name != null and name != ''">
name like concat('%',#{name},'%')
</if>
<if test="gender != null">
and gender = #{gender}
</if>
<if test="begin != null and end != null">
and entrydate between #{begin} and #{end}
</if>
</where>
** order by update_time desc
limit #{start},{pageSize}**