sql·Ö×éͳ¼ÆÎÊÌâ

ÏÖÔÚÓÐÒ»Õűí
ÄÐ A
ÄÐ D
Å® A
ÄÐ B
ÄÐ A
Å® C
ÄÐ D
Å® A
ÄÐ B
Å® A

ÎÒÏëµÃµ½µÄ½á¹ûÊÇ
  A    B  C  D
ÄÐ 2    2  0  2
Å® 3    0  1  0

¸ßÊÖ³öÕУ¡

---

SQL code:
select cola,
sum(case when colb='a' then 1 else 0 end )A,
sum(case when colb='b' then 1 else 0 end )B,
sum(case when colb='c' then 1 else 0 end )C,
sum(case when colb='d' then 1 else 0 end )D
from tb group by cola

---

SQL code:
select
col1,
sum(case when col2='A' then 1 else 0 end) as A,
sum(case when col2='B' then 1 else 0 end) as B,
sum(case when col2='C' then 1 else 0 end) as C,
sum(case when col2='D' then 1 else 0 end) as D
from
tb
group by
col1

---

SQL code:


--> ²âÊÔÊý¾Ý£º[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([col1] varchar(2),[col2] varchar(1))
insert [TB]
select 'ÄÐ','A' union all
select 'ÄÐ','D' union all
select 'Å®','A' union all
select 'ÄÐ','B' union all
select 'ÄÐ'