17,086
社区成员
发帖
与我相关
我的任务
分享
--之前别名有点问题 type_C
SELECT XZQY,
NVL(SUM(DECODE(TYPE, 'A', AREA)), 0) TYPE_A,
NVL(SUM(DECODE(TYPE, 'B', AREA)), 0) TYPE_B,
NVL(SUM(DECODE(TYPE, 'C', AREA)), 0) TYPE_C
FROM TBL
GROUP BY XZQY
SELECT XZQY,
NVL(SUM(DECODE(TYPE, 'A', AREA)), 0) TYPE_A,
NVL(SUM(DECODE(TYPE, 'B', AREA)), 0) TYPE_B,
NVL(SUM(DECODE(TYPE, 'C', AREA)), 0) TYPE_B
FROM TBL
GROUP BY XZQY