<select id="todayTurnoverMoney" parameterType="Orders" resultType="java.lang.Double">
select COALESCE(sum(paymoney),0) from orders where paydate >= #{paydate} and sellerid=#{sellerid}
select COALESCE(sum(paymoney),0) from orders where paydate >= #{paydate} and sellerid=#{sellerid}
</select>
COALESCE(sum(paymoney),0) :返回参数中的第一个非空表达式(从左向右)