我正在嘗試獲取每個月的生產總和，并將月行轉為列。你能告訴我這段代碼有什么問題嗎？
select *
from (
select datename(month,day), UnitId, sum(pv_production) as production, year(day)
from MeterReading
group by datename(month,day), UnitId, year(day)) p
pivot (
max(pv_production) for datename(month, day) in ([January], [February], [March], [April], [May], [June], [July], [August], [September], [October], [November], [December]
)
) as pp
uj5u.com熱心網友回復：
您的查詢中有幾項錯誤。列需要別名，并且 PIVOT 中的 max() 參考了無效的列名
Select *
From (
Select [Month] = datename(month,day)
, [Year] = year(day)
, UnitId
, production = sum(pv_production)
From MeterReading
Group By datename(month,day)
,year(day)
,UnitId
) Src
Pivot ( max(production) for [Month] in ([January]
,[February]
,[March]
,[April]
,[May]
,[June]
,[July]
,[August]
,[September]
,[October]
,[November]
,[December] ) ) Pvt
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/453215.html
上一篇：在相同的頂部位置開始div