/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

9 votes263 views4 answers
SQL Date Format
SQL
4 votes396 views6 answers
Laravel jwt
SQL
0 vote249 views1 answer
Set open file limit mac catalina mysql
SQL
2 votes277 views2 answers
Calculate percentage in sql
SQL
1 vote242 views1 answer
Set statiscis on in sql server
SQL
-1 vote304 views4 answers
Full outer join in sql
SQL
0 vote248 views1 answer
Sql server python connection
SQL
2 votes260 views1 answer
Mysql application.properties spring boot
SQL
10 votes255 views2 answers
Linux command line import mysql database
SQL
17 votes268 views4 answers
Mysql remove ubuntu
SQL