求1的个数:SUM(case 字段A when 1 then 1 else 0 end) 求0的个数:SUM(case 字段A when 0 then 1 else 0 end) 求NULL个数:SUM(case when 字段A is null then 1 else 0 end)
select sum(case when 字段A=0 then 1 else 0 end)[为0的行数], sum(case when 字段A is null then 1 else 0 end)[为NULL的行数 from tb
sum(case when col is null then 1 else 0 end)
select sum(case when 字段A=0 then 1 else 0 end)[为0的行数], sum(case when 字段A is null then 1 else 0 end)[为NULL的行数] from tb
sum(case when 字段A =0 then 1 else 0 end) as 求0的个数 sum(case when 字段A =1then 1 else 0 end) as 求1的个数 sum(case when 字段A is null then 1 else 0 end) as 求NULL个数
求0的个数:SUM(case 字段A when 0 then 1 else 0 end)
求NULL个数:SUM(case when 字段A is null then 1 else 0 end)
sum(case when 字段A is null then 1 else 0 end)[为NULL的行数
from tb
sum(case when 字段A is null then 1 else 0 end)[为NULL的行数]
from tb
sum(case when 字段A =1then 1 else 0 end) as 求1的个数
sum(case when 字段A is null then 1 else 0 end) as 求NULL个数