我要查询表中某个列的最大值:
<insert id="selectMaxVersionByType">
select
max(version)
from aton_agreement
where type = #{type}
</insert>
结果一直返回-1
改成以下形式:
<select id="selectMaxVersionByType" resultType="java.lang.Integer">
select
max(version)
from aton_agreement
where type = #{type}
</select>
结果返回正确