declare @year varchar(4)='2020'
SELECT
@year as 'year',
MONTH (日期字段) as 'month' ,
count(*) as counts --这里也可以写sum之类函数
FROM
表名
WHERE
YEAR ( 日期字段 ) = @year
GROUP BY
MONTH ( 日期字段 )
运行结果
year month counts
2020 1 5854
2020 2 13760
2020 3 5055
2020 4 4894
2020 5 8939
2020 6 315