分页加排序

	    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 &lt;=#{end} 
		)
		where rn &gt;=#{start}