SELECT name,
SUM(CASE WHEN zt=0 THEN 1 ELSE 0 END) [ztnum0],
SUM(CASE WHEN zt=1 THEN 1 ELSE 0 END) [ztnum1]
FROM tb_name
GROUP BY name
SUM(CASE WHEN zt=0 THEN 1 ELSE 0 END) [ztnum0],
SUM(CASE WHEN zt=1 THEN 1 ELSE 0 END) [ztnum1]
FROM tb_name
GROUP BY name
ztnum1=sum(case zt when 1 then 1 else 0 end)
from tb group by name
我是要统计name对应的zt为1,0的次数