sql - 我如何总结每个产品的每个月的数据？

Question

我有一组数据，例如：

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

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

标签： sqlgroup-bysumsql-order-by

Answer 1

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

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