在SQL Server查询中获取按月数据

SELECT DATEPART(year, YourDateColumn) AS Year,
       DATEPART(month, YourDateColumn) AS Month,
       SUM(YourNumericColumn) AS Total
FROM YourTable
GROUP BY DATEPART(year, YourDateColumn), DATEPART(month, YourDateColumn)
ORDER BY Year, Month;

SELECT DATEADD(month, DATEDIFF(month, 0, YourDateColumn), 0) AS StartOfMonth,
       DATEADD(month, DATEDIFF(month, 0, YourDateColumn) + 1, 0) AS EndOfMonth,
       SUM(YourNumericColumn) AS Total
FROM YourTable
WHERE YourDateColumn BETWEEN DATEADD(month, DATEDIFF(month, 0, YourDateColumn), 0)
                          AND DATEADD(month, DATEDIFF(month, 0, YourDateColumn) + 1, 0)
GROUP BY DATEADD(month, DATEDIFF(month, 0, YourDateColumn), 0),
         DATEADD(month, DATEDIFF(month, 0, YourDateColumn) + 1, 0)
ORDER BY StartOfMonth;