select type,sum(case when NumA=1 then 1 else 0 end) numA1,sum(case when NumA=2 then 1 else 0 end) numA2,sum(case when NumB=1 then 1 else 0 end) numB1,,sum(case when NumB=2 then 1 else 0 end) numB2 from tb group by type
select type,sum(case when NumA=1 then 1 else 0 end) numA1 ,sum(case when NumA=2 then 1 else 0 end) numA2 ,sum(case when NumB=1 then 1 else 0 end) numB1 ,sum(case when NumB=2 then 1 else 0 end) numB2 from tb group by type
from tb group by type
select type,sum(case when NumA=1 then 1 else 0 end) numA1,sum(case when NumA=2 then 1 else 0 end) numA2,sum(case when NumB=1 then 1 else 0 end) numB1,,sum(case when NumB=2 then 1 else 0 end) numB2
from tb group by type
select type,sum(case when NumA=1 then 1 else 0 end) numA1
,sum(case when NumA=2 then 1 else 0 end) numA2
,sum(case when NumB=1 then 1 else 0 end) numB1
,sum(case when NumB=2 then 1 else 0 end) numB2
from tb
group by type