求一条mysql查询语句

11 |

4 | 2013-3-12 10:12:43 | 显示全部楼层 |阅读模式

SELECT CODE, SUM(IF(TYPE = 'a', 1, 0)) 'a的个数', SUM(IF(TYPE = 'b', 1, 0)) 'b的个数', SUM(IF(TYPE = 'c', 1, 0)) 'c的个数'FROM abcGROUP BY CODE...

使用道具举报

千问 | 2013-3-12 10:12:43 | 显示全部楼层

select code,sum(case type when 'a' then 1 else o end)as a的个数,sum(case type when 'b' then 1 else o end)as b的个数,sum(case type when 'c' then 1 else o end)as c的个数from table...

使用道具举报

千问 | 2013-3-12 10:12:43 | 显示全部楼层

select
code,
sum(case when type = a then 1 else 0 end) as a的个数,
sum(case when type = b then 1 else 0 end) as b的个数,
sum(case when type = c then 1 else 0 end)...

使用道具举报