/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 vote262 views1 answer
Mariadb maximum left join
SQL
0 vote282 views1 answer
SQL column name Oracle
SQL
1 vote274 views1 answer
Mysql select all and rename one
SQL
12 votes248 views1 answer
Create column sql server
SQL
0 vote281 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote250 views1 answer
Minecraft duping allowed servers
SQL
0 vote273 views2 answers
Athena drop partition
SQL
0 vote258 views1 answer
Oracle execute package dblink
SQL
5 votes285 views3 answers
Show indexes mysql
SQL
1 vote258 views1 answer
Show table status command in mysql
SQL