现有原始数据表:SELECT * FROM FIX_0528_ADD
需要将FMONTH字段行转成列,汇总FADD数量:
SELECT FNAME,[2022-01],[2022-02],[2022-03],[2022-04]
FROM FIX_0528_ADD
PIVOT(SUM(FADD) FOR FMONTH IN ([2022-01],[2022-02],[2022-03],[2022-04])) T
执行后结果:
现有原始数据表:SELECT * FROM FIX_0528_ADD
需要将FMONTH字段行转成列,汇总FADD数量:
SELECT FNAME,[2022-01],[2022-02],[2022-03],[2022-04]
FROM FIX_0528_ADD
PIVOT(SUM(FADD) FOR FMONTH IN ([2022-01],[2022-02],[2022-03],[2022-04])) T
执行后结果: