我在postgres 10中创建了这个表，下面两种方法都有效:

从我们中选择count(*)

and

从我们中选择count(a为空)

我通常用这个技巧

select sum(case when a is null then 0 else 1 end) as count_notnull,
       sum(case when a is null then 1 else 0 end) as count_null
from tab
group by a

用于计数非空值

select count(*) from us where a is not null;

用于计算空值

 select count(*) from us where a is null;

这适用于Oracle和SQL Server(你可能可以让它在其他RDBMS上工作):

select sum(case when a is null then 1 else 0 end) count_nulls
     , count(a) count_not_nulls 
  from us;

Or:

select count(*) - count(a), count(a) from us;

正如我理解你的查询，你只需要运行这个脚本并获得Total Null,Total NotNull行，

select count(*) - count(a) as 'Null', count(a) as 'Not Null' from us;

在我的例子中，我想要多列之间的“空分布”:

SELECT
       (CASE WHEN a IS NULL THEN 'NULL' ELSE 'NOT-NULL' END) AS a_null,
       (CASE WHEN b IS NULL THEN 'NULL' ELSE 'NOT-NULL' END) AS b_null,
       (CASE WHEN c IS NULL THEN 'NULL' ELSE 'NOT-NULL' END) AS c_null,
       ...
       count(*)
FROM us
GROUP BY 1, 2, 3,...
ORDER BY 1, 2, 3,...

根据“……它可以很容易地扩展到更多的列，只要需要