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
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！