温馨提示:本文翻译自stackoverflow.com,查看原文请点击:sql - How do I sum up each Month of data for each product?
group-by sql sum sql-order-by

sql - 如何汇总每个产品的每个月数据?

发布于 2020-03-29 22:07:39

我有一组数据,例如:

Date        Product    Volume
01-01-2020  A          5
02-01-2020  A          25
03-01-2020  B          20
02-01-2020  B          10
04-01-2020  C          5
02-02-2020  A          30
02-02-2020  B          25
01-02-2020  C          25
01-02-2020  C          40
04-02-2020  C          100
01-03-2020  A          5
01-03-2020  B          0
01-03-2020  A          50

输出将类似于:

Date        Product    Monthly Volume
01-01-2020  A          30
01-01-2020  B          40
01-01-2020  C          5
01-02-2020  A          30
01-02-2020  B          25
01-02-2020  C          165
01-03-2020  A          55
01-03-2020  B          0

希望这是有道理的。感谢您提前提供的所有帮助=)

查看更多

提问者
sam
被浏览
75
PaulS 2020-01-31 19:07

您可以月份和产品分组,例如

SELECT Product, MONTH(Date), Sum(Volume) As Monthly Volume
FROM table
GROUP BY MONTH(Date), Product