/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

6 votes270 views1 answer
How to count number of rows in sql
SQL
0 vote268 views2 answers
Mysql slave status
SQL
0 vote345 views1 answer
Hierarchal database table
SQL
0 vote287 views1 answer
Oracle current session details
SQL
1 vote267 views1 answer
Mysql find tables with column name
SQL
0 vote271 views1 answer
How to check which sp is running in sql server
SQL
0 vote319 views1 answer
How to get table id sequence postgres
SQL
1 vote270 views2 answers
Reset mysqli fetch_arra
SQL
0 vote325 views1 answer
Remove mysql from centos 7
SQL
0 vote283 views1 answer
Oracle c# multiple update sql
SQL