SQL Server 按月或年分组查询

MONTH

将date 取值，取其月份

YEAR

将date取值，取其年份

分组查询

一张 table ，叫 summary(日期为 DD-MM-YYYY):

id	c_summary	c_time
1	5	2022-01-01

假如按月分组

SELECT MONTH(c_time) AS month, SUM(c_summary )
FROM summary
GROUP BY MONTH(c_time)

假如按年分组

SELECT YEAR(c_time) AS year, SUM(c_summary )
FROM summary
GROUP BY YEAR(c_time)