select count(1) from ( select ltrim(name) name from [Table] where id=1 union all select ltrim(areaid) name from [Table] where id=1 union all select ltrim(sex) name from [Table] where id=1 )aa where name is null
or select case when name is null then 1 else 0 end+ case when areaid is null then 1 else 0 end+ case when sex is null then 1 else 0 end from [Table] where id=1
select sum( case when name is null then 1 else 0 end+ case when areaid is null then 1 else 0 end+ case when sex is null then 1 else 0 end) from tb
select sum( case when name is null then 1 else 0 end+ case when areaid is null then 1 else 0 end+ case when sex is null then 1 else 0 end) from tb 嗯,这个行, 除了为NULL的,为 '' 的也要统计呢?
嗯,这个行, 除了为NULL的,为 '' 的也要统计呢?
select sum( case when isnull(name,'')='' then 1 else 0 end+ case when isnull(areaid,'')='' then 1 else 0 end+ case when isnull(sex,'')='' then 1 else 0 end) from tb
(
select ltrim(name) name from [Table] where id=1
union all
select ltrim(areaid) name from [Table] where id=1
union all
select ltrim(sex) name from [Table] where id=1
)aa where name is null
select case when name is null then 1 else 0 end+
case when areaid is null then 1 else 0 end+
case when sex is null then 1 else 0 end
from [Table] where id=1
case when name is null then 1 else 0 end+
case when areaid is null then 1 else 0 end+
case when sex is null then 1 else 0 end)
from tb
select sum(
case when name is null then 1 else 0 end+
case when areaid is null then 1 else 0 end+
case when sex is null then 1 else 0 end)
from tb
嗯,这个行,
除了为NULL的,为 '' 的也要统计呢?
嗯,这个行,
除了为NULL的,为 '' 的也要统计呢?
case when isnull(name,'')='' then 1 else 0 end+
case when isnull(areaid,'')='' then 1 else 0 end+
case when isnull(sex,'')='' then 1 else 0 end)
from tb