/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 vote257 views1 answer
SQL check if record exist
SQL
0 vote186 views1 answer
Get who is hired in january in sql
SQL
0 vote190 views1 answer
Tsql pad left
SQL
0 vote135 views1 answer
Check sql query executed wp
SQL
1 vote295 views1 answer
Oracle current sequence value
SQL
34 votes227 views6 answers
Install mysql client ubuntu
SQL
11 votes187 views4 answers
Update row in mysql
SQL
0 vote239 views1 answer
Mysql installer no packages found
SQL
2 votes214 views1 answer
Search query in mysql
SQL
3 votes230 views1 answer
Delete all content in table mysql
SQL