sqlでpivotテーブル
sqlでpivotテーブル
SELECT a,b,c ,'aa','bb','cc' from abc
PIVOT (" sum(ddd) FOR a IN ( ,'aa','bb','cc') ) AS PV
sqlでpivotテーブル.txt · 最終更新: 2019/06/30 12:22 by 127.0.0.1
sqlでpivotテーブル
SELECT a,b,c ,'aa','bb','cc' from abc
PIVOT (" sum(ddd) FOR a IN ( ,'aa','bb','cc') ) AS PV