select * from(
select t.*,rownum rn from(
select
<include refid="Base_Column_List" />
from JULONG_PROPERTIES c
<where>
<if test="key!=null and key!=''">and KEY like concat(concat('%',# {key,jdbcType=VARCHAR}),'%')</if>
<if test="value!=null and value!=''">and VALUE = #{value,jdbcType=VARCHAR}</if>
<if test="1==1">and IS_DEL=1</if>
</where> ***order by id***
) t
where rownum <=#{end}
)
where rn >=#{start}
分页加排序
最新推荐文章于 2023-12-20 11:09:27 发布