56,677
社区成员
发帖
与我相关
我的任务
分享
test
ID dep leixing other
1 A 类型1 asdfs
2 A 类型1 fawef
3 B 类型2 aewf
4 B 类型3 fasdf
5 A 类型2 sf
6 A 类型3 af
7 A 类型3 awef
dep l1 l2 l3
A 2 1 2
B 0 1 1
with a as (select dep,leixing,count(*) as lxcount from test group by dep,leixing)
select dep,sum( case leixing when '类型1' then lxcount else 0 end)l1,
sum( case leixing when '类型2' then lxcount else 0 end)l2,
sum( case leixing when '类型3' then lxcount else 0 end)l3
from a group by dep
select dep,sum(case type when 1 then 1 else 0 end) as T1, sum(case type when 2 then 1 else 0 end)as T2, sum(case type when 3 then 1 else 0 end)ass T3 from type group by dep;
select dep,sum( case leixing when '类型1' then 1 else 0 end)l1,
sum( case leixing when '类型2' then 1 else 0 end)l2,
sum( case leixing when '类型3' then 1 else 0 end)l3
from a group by dep