/SQL/Sql query to find percentage of null values in a table

Sql query to find percentage of null values in a table

SELECT 100.0 * SUM(CASE WHEN Column1 IS NULL THEN 1 ELSE 0 END) / COUNT(*) AS Column1Percent,
100.0 * SUM(CASE WHEN Column2 IS NULL THEN 1 ELSE 0 END) / COUNT(*) AS Column2Percent,
100.0 * SUM(CASE WHEN Column3 IS NULL THEN 1 ELSE 0 END) / COUNT(*) AS Column3Percent
FROM #perc

Source: blogs.lessthandot.com

Similar codes

0 vote144 views1 answer
Tsql generate rows
SQL
0 vote147 views1 answer
Mysql table variables
SQL
0 vote169 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote141 views1 answer
Full syntax inner join
SQL
-1 vote165 views3 answers
How to restart mysql in linux
SQL
0 vote156 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote175 views1 answer
Connect postgresql using a connection string
SQL
0 vote149 views2 answers
Sql last updated
SQL
0 vote156 views1 answer
Mysql multiple primary keys
SQL
0 vote147 views1 answer
Oracle sql log to console
SQL