列表上移下移的SQL语句（mybatis mapper.xml写法）

<!-- 上移 -->
<select id="selectPushsortValue"  resultType="Long" parameterType="java.util.Map" >
select coalesce(max(sort_value),0) from content_push_detail cpd
where sort_value <![CDATA[ < ]]> #{sortValue}
and cpd.content_push_id=#{contentPushId}
</select>


<!-- 下移 -->
<select id="selectPushMinsortValue"  resultType="Long" parameterType="java.util.Map" >
select coalesce(min(sort_value),0) from content_push_detail cpd
where sort_value <![CDATA[ > ]]> #{sortValue}
and cpd.content_push_id=#{contentPushId}
</select>