我需要你的帮助。我在 mysql 中有以下数据,我的要求是按月汇总金额。
Amount == Date
5000 || 01-05-2017 //Month May
6000 || 05-05-2017 //Month May
7000 || 20-05-2017 //Month May
10000 || 01-06-2017 //Month June
12000 || 05-06-2017 //Month June
13000 || 20-06-2017 //Month June
预期成果:
Sum = May 18000
Sum = June 35000
Sum = July 111111
SELECT
SUM(AMOUNT),
DATE_FORMAT(DATE_COLUMN,'%M')
FROM TABLENAME
GROUP BY DATE_FORMAT(DATE_COLUMN,'%m')
尝试上面的代码。
希望这会有所帮助。
将SUM
聚合函数与 GROUP BY
和 dateTime 函数一起使用
SELECT
SUM(AmountColumn),
DATE_FORMAT(record_date, '%M %Y') AS MONTH
FROM
table_name
GROUP BY
DATE_FORMAT(record_date, '%M %Y')