mysql 月度统计累计

实测 正确 上个月的统计累计当前月的统计

SELECT
a.tradeDate,
a.count,
sum( b.balances ) AS balances
FROM
(
SELECT
date_format( trade1.onLoanDate, ‘%Y/%m’ ) AS tradeDate,
SUM( trade1.balances ) AS balances,
count(1) AS count
FROM
trade1
GROUP BY
tradeDate
) AS a
JOIN (
SELECT
date_format( trade1.onLoanDate, ‘%Y/%m’ ) AS tradeDate,
SUM( trade1.curDayApplyAmtAdd ) AS balances
FROM
trade1
GROUP BY
tradeDate
) AS b
on a.tradeDate >= b.tradeDate