SQL Server 中有许多内置函数可以用于按月统计数据。其中一些常用的函数包括:
- DATEPART 函数:可以用来提取日期中的月份部分,例如:
SELECTDATEPART(month, OrderDate) AS [Month], COUNT(*) AS [Total Orders]
FROM Orders
GROUP BY DATEPART(month, OrderDate)
- DATENAME 函数:可以用来将月份转换为月份名称,例如:
SELECTDATENAME(month, OrderDate) AS [Month], COUNT(*) AS [Total Orders]
FROM Orders
GROUP BY DATENAME(month, OrderDate)