SQL資料直式轉橫式作法

STK QTY
----- -------
X X



select pdno,pdid,gd,un,
sum(CASE WHEN co='2*8' and stk='R' THEN qty ELSE 0 END) "TWR",
sum(CASE WHEN co='2*8' and stk='L' THEN qty ELSE 0 END) "TWL",
sum(CASE WHEN co='2*8' and stk='5' THEN qty ELSE 0 END) "TW5",
sum(CASE WHEN co='2*8' and stk='9' THEN qty ELSE 0 END) "TW9",
sum(CASE WHEN co='2*8' and stk='B' THEN qty ELSE 0 END) "TWB",
sum(CASE WHEN co='CL*' and stk='C' THEN qty ELSE 0 END) "CLC",
sum(CASE WHEN co='CQ8' and stk='Q' THEN qty ELSE 0 END) "CQQ",
sum(CASE WHEN co='CG8' and stk='F' THEN qty ELSE 0 END) "CGF",
sum(CASE WHEN co='CG8' and stk='G' THEN qty ELSE 0 END) "CGG"
from vhkgfa02_all
group by pdno,pdid,gd,un;