PIVOT运算符中指定的列名“ irstName”与PIVOT参数中的现有列名冲突

您可以

CTE

;WITH tAS (    SELECt isnull(jan, 0) AS jan        ,isnull(feb, 0) AS feb        ,sum(data) AS amount    FROM your_table --change this to match your table name    GROUP BY jan,feb    )SELECt *FROM (    SELECt t.jan        ,t.feb        ,t.amount    FROM t    )pivot(sum(amount) FOR [month] IN ( jan ,feb )) AS piv