获取列值不为NULL的每个列计数 [英] Get each column count where column value is not NULL

问题描述

我有一个表，该表中有5列.我想要其中列值不为null的每一列的行计数.

I have a table and 5 columns in the table. I want row count for each column where column value is not null.

column1 column2 column3 column4 column5
1        2        2       2        2
2        2        2       NULL     2     
3        NULL     2       2        NULL
NULL     NULL     2       2        NULL
NULL     NULL     2       2        NULL

我应该得到类似3,2,5,4,2的输出

i should get output like 3,2,5,4,2

推荐答案

提供的解决方案不适用于我.我不得不按如下方式修改代码:

The solutions offered did not work for me. I had to modify the code as follows:

SELECT 
COUNT(NULLIF(Column1,'')),
COUNT(NULLIF(Column2,'')),
COUNT(NULLIF(Column3,'')),
COUNT(NULLIF(Column4,'')),
COUNT(NULLIF(Column5,''))
FROM Table1

这篇关于获取列值不为NULL的每个列计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！