Multiple SQL statements together?

[Nykeriab]

I am testing each column in a table to see if it has null values. Currently, I am using:

select count (column) when column is not null

I have a list of 20 of these for each column. Can I combine them all to run it once and then tell me the record count for each column. Any column that has 0 would be a null column

[zymir]

The where clause is redundant. You can just add all to a single query:

select count(column1),
       count(column2),
       . . .
       count(column20)      
from t