22,209
社区成员
发帖
与我相关
我的任务
分享
select
sum(case when 名字='甲' then 1 else 0 end) as [甲],
sum(case when 名字='乙' then 1 else 0 end) as [乙],
sum(case when 名字='丙' then 1 else 0 end) as [丙]
from tb
where year='2011'
select
sum(case when 名字='甲' then 1 else 0 end) as 甲,
sum(case when 名字='乙' then 1 else 0 end) as 乙,
sum(case when 名字='丙' then 1 else 0 end) as 丙
from tb where 年份=2011