oracle复杂统计,如何做处理
怎么处理这样复杂的统计?
------解决方案--------------------
给出表结构和数据
------解决方案--------------------
这会用到decode函数等
------解决方案--------------------
--gz:工种 state:标示报名状态 jb:级别
select gz,
sum(case when state=1 and jb='初级工' then 1 else 0 end) type11,
sum(case when state=1 and jb='中级工' then 1 else 0 end) type12,
sum(case when state=1 and jb='高级工' then 1 else 0 end) type13,
sum(case when state=1 and jb='高级技师' then 1 else 0 end) type14,
sum(case when state=2 and jb='初级工' then 1 else 0 end) type21,
sum(case when state=2 and jb='中级工' then 1 else 0 end) type22,
sum(case when state=2 and jb='高级工' then 1 else 0 end) type23,
sum(case when state=2 and jb='高级技师' then 1 else 0 end) type24,
sum(case when state=3 and jb='初级工' then 1 else 0 end) type31,
sum(case when state=3 and jb='中级工' then 1 else 0 end) type32,
sum(case when state=3 and jb='高级工' then 1 else 0 end) type33,
sum(case when state=3 and jb='高级技师' then 1 else 0 end) type34
from table_name
group by gz
供参考