SQL

select distinct ptypename,sum(prairiearea) from DGM_PRAIRIETYPE group by ptypename

---prairietype

 

<!-- 统计 -->
<select id="prairieTypeStatisList" resultMap="BaseResultMap" parameterType="java.lang.String" >

select ptypename,sum(prairiearea) PRAIRIEAREA from DGM_PRAIRIETYPE
where deptcode = #{deptcode,jdbcType=VARCHAR}
group by ptypename
</select>