SQL面试题（十三）

问题:

报表查询横向输出

1  gly

2  ptgly

3  ybgly

4  ptgly

5  ybgly
查询后的结果：
+---+-----+------+
|gly|ptgly|ybgly |     
|---+-----+------+-
|1  |2    |2     |
+---+-----+------+

 

建表：

Create table d(id int,name varchar(50));
insert into d values(1,'gly');
insert into d values(2,'ptgly');
insert into d values(3,'ybgly');
insert into d values(4,'ptgly');
insert into d values(5,'ybgly');

 

Sql：

select 
      sum(case when name='gly' then 1 else 0 end ) as gly  ,
      sum(case when name='ptgly' then 1 else 0 end ) as ptgly  ,
      sum(case when name='ybgly' then 1 else 0 end ) as ybgly  
      from d ;

 

结果:

 

+------+-------+-------+

| gly  | ptgly | ybgly |

+------+-------+-------+

|    1 |     2 |     2 |

+------+-------+-------+