Question

sql非空值统计

想统计表内某字段空值多少，非空值多少，是用什么语句。？

Answer 1

select count(isnull(字段名)) as '空值', count(not isnull(字段名)) as '非空值'
from 表

试试。

追问

结果报错
isnull 函数要求有2个参数

Answer 2

select sum((case when col1 is null then 1 else 0 end))空值,
sum((case when col1 is not null then 1 else 0 end)) 非空值,
from table_name

Answer 3

select count(字段) 非空值, count(case when 字段 is null then 1 end) 空值
from 表

Answer 4

select a.a as '空值', b.b as '非空值' from
(select count(字段) as a from 表名 where 字段 is null )a,
(select count(字段) as b from 表名 where 字段 is not null ) b