--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供参考
--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供参考