nvl的意思是,如果invoice_sum的和为null,则返回0,
下面中的意思是排除这个Id本身的值。
<select id="checkInvoiceSumByPayId" parameterType="FdContractPaymentr" resultType="String">
select nvl(sum(invoice_sum),0) from fd_contract_paymentr where pay_id = #{payId}
<if test="id !=null and id != ''">
and id != #{id}
</if>
</select>