/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 vote131 views1 answer
Oracle string length
SQL
5 votes144 views2 answers
Oracle rename table
SQL
1 vote158 views1 answer
Sql server loop over query
SQL
0 vote136 views1 answer
Get last three characters in mysql column
SQL
0 vote133 views1 answer
Postgres list tables and row counts
SQL
5 votes182 views1 answer
Mysql created at yesterdau
SQL
0 vote131 views1 answer
Subquery aggregation
SQL
2 votes150 views1 answer
Column names in oracle sql
SQL
0 vote138 views1 answer
Provide hardcoded value in the mysql query
SQL
4 votes145 views3 answers
Is not null sql
SQL