问一个SQL语句怎么写？数据库系统是SQLSERVER2000，请各位指教
我们有一个表是存的是下面的数据
入煤 出煤 日期
100 200 1999/1/2
200 200 1999/2/23
.......
现想建一个视图按照年月来累加统计，SQLSERVER中有DATEPART函数，但只能
用来统计年的，到月怎么累加分组呀？请各位帮帮忙好吗？
按年统计的我已解决：
SELECT SUM(EnterCoal) AS entercoal, SUM(CostCoal) AS costcoal, SUM(KeepCoal)
AS keepcoal, DATEPART(yy, [Date]) AS year
FROM dbo.POM_COAL_DATA
GROUP BY DATEPART(yy, [Date])
可按月怎么写呀？
---------------------------------------------------------------
SELECT SUM(EnterCoal) AS entercoal, SUM(CostCoal) AS costcoal, SUM(KeepCoal)
AS keepcoal, DATEPART(yy, [Date]) AS year,DATEPART(mm, [Date]) AS month
FROM dbo.POM_COAL_DATA
GROUP BY DATEPART(yy, [Date]),DATEPART(mm, [Date])
---------------------------------------------------------------
GROUP BY DATEPART(yy, [Date]),
DATEPART(mm, [Date]),
不可以吗？很长时间没用了：）
---------------------------------------------------------------
SELECT SUM(EnterCoal) AS entercoal, SUM(CostCoal) AS costcoal, SUM(KeepCoal)
AS keepcoal, YEAR([Date] AS [year],MONTH([Date]) AS [MONTH]
FROM dbo.POM_COAL_DATA
GROUP BY YEAR([Date] AS [year],MONTH([Date]) AS [MONTH]
---------------------------------------------------------------
to: jinzhum (马克)
SQLSERVER中有DATEPART函数，但只能
用来统计年的，到月怎么累加分组呀？
嗯，不会吧，可以用来统计月的吧。DATEname(month, [Date])不行吗？