select sum(decode(dj,'A',sum值,0)) a,sum(decode(dj,'B',sum值,0)) b,sum(decode(dj,'C',sum值,0)) c,sum(decode(dj,'不予',sum值,0)) 不予 from 表 group by orgcode
with tab AS( SELECT '011301' ORGCODE,13 SUMN,'A' dj FROM dual UNION ALL SELECT '011301',353,'B' FROM dual UNION ALL SELECT '011301',19,'C' FROM dual UNION ALL SELECT '011301',2,'不予' FROM dual) SELECT SUM(DECODE(DJ, 'A', SUMN, 0)) A, SUM(DECODE(DJ, 'B', SUMN, 0)) B, SUM(DECODE(DJ, 'C', SUMN, 0)) C, SUM(DECODE(DJ, '不予', SUMN, 0)) 不予 FROM TAB GROUP BY ORGCODE
大神就是大神 可惜我sql没学好 啊
with t as( select '011301' orgcode,13 sumor,'A' dj from dual union all select '011301',353,'B' from dual union all select '011301',19,'C' from dual union all select '011301',2,'不予评级' from dual) select orgcode,max(decode(DJ,'A',sumor,null)) A,max(decode(DJ,'B',sumor,null)) B,max(decode(DJ,'C',sumor,null)) C,max(decode(DJ,'不予评级',sumor,null)) 不予 from t group by orgcode
SELECT '011301' ORGCODE,13 SUMN,'A' dj FROM dual UNION ALL
SELECT '011301',353,'B' FROM dual UNION ALL
SELECT '011301',19,'C' FROM dual UNION ALL
SELECT '011301',2,'不予' FROM dual)
SELECT SUM(DECODE(DJ, 'A', SUMN, 0)) A,
SUM(DECODE(DJ, 'B', SUMN, 0)) B,
SUM(DECODE(DJ, 'C', SUMN, 0)) C,
SUM(DECODE(DJ, '不予', SUMN, 0)) 不予
FROM TAB
GROUP BY ORGCODE
select '011301' orgcode,13 sumor,'A' dj from dual union all
select '011301',353,'B' from dual union all
select '011301',19,'C' from dual union all
select '011301',2,'不予评级' from dual)
select orgcode,max(decode(DJ,'A',sumor,null)) A,max(decode(DJ,'B',sumor,null)) B,max(decode(DJ,'C',sumor,null)) C,max(decode(DJ,'不予评级',sumor,null)) 不予
from t
group by orgcode