/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 vote213 views1 answer
Like date sql server not working
SQL
0 vote236 views1 answer
Sql query to select even numbers
SQL
7 votes226 views1 answer
Oracle pagination query rownum
SQL
0 vote208 views1 answer
Mysql custom sort order
SQL
1 vote211 views1 answer
Sql set auto increment back to 0
SQL
1 vote199 views1 answer
Sql run multiple updates in one query
SQL
0 vote211 views1 answer
Sql server on mac m1
SQL
0 vote188 views3 answers
Sql all columns
SQL
10 votes206 views2 answers
Show tables in schema oracle
SQL
1 vote190 views2 answers
Mysql type conversion
SQL