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])
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])
DATEPART(mm, [Date]),
不可以吗?很长时间没用了:)
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]
SQLSERVER中有DATEPART函数,但只能
用来统计年的,到月怎么累加分组呀?嗯,不会吧,可以用来统计月的吧。DATEname(month, [Date])不行吗?
CSDNM(CSDN经理(信就不假)说的都对30
好了,十分感谢大家