select
dwxh 单位序号
,sum(decode(qxflbh,'a',hzsm,0)) 缺陷编号a汇总数目
,sum(decode(qxflbh,'b',hzsm,0)) 缺陷编号b汇总数目
,sum(decode(qxflbh,'c',hzsm,0)) 缺陷编号c汇总数目
from test group by dwxh
/
select
dwxh 单位序号
,sum(case when qxflbh = 'a' then hzsm else 0 end) 缺陷编号a汇总数目
,sum(case when qxflbh = 'b' then hzsm else 0 end) 缺陷编号b汇总数目
,sum(case when qxflbh = 'c' then hzsm else 0 end) 缺陷编号c汇总数目
from test group by dwxh
/