/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 vote221 views1 answer
Mysql_union
SQL
104 votes350 views2 answers
Like in mysql
SQL
3 votes212 views1 answer
Oracle detect invalid password
SQL
0 vote219 views1 answer
Mysql delete from where like
SQL
0 vote208 views1 answer
Import sql mysql ubuntu
SQL
0 vote227 views1 answer
Sqlite to csv statement
SQL
0 vote236 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
6 votes235 views1 answer
Oracle list primary key
SQL
0 vote221 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
6 votes251 views2 answers
Mysql timestamp to date
SQL