SELECT
DATE_FORMAT(t.`payDateTime`, "%Y-%m") month,
COUNT(1) num,
IFNULL(SUM(payMoney), 0) sumAmount
FROM
trade t
<where>
<if test="beginTime != null and endTime != null">
t.payDateTime >= #{beginTime}
AND t.payDateTime < #{endTime}
</if>
<if test="tradeType != null and tradeType != ''">
AND tradeType = #{tradeType}
</if>
</where>
GROUP BY DATE_FORMAT(t.`payDateTime`, "%Y-%m");
Mysql统计平台每月的交易金额和交易笔数
最新推荐文章于 2023-12-19 20:40:37 发布