/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

1 vote274 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
-2 votes196 views3 answers
Oracle tablespace usage
SQL
0 vote205 views1 answer
Declare or use variable in snowflake
SQL
0 vote198 views1 answer
Mysql with
SQL
0 vote255 views1 answer
Mysql grant user wildcard database
SQL
0 vote213 views1 answer
Sql query to get column names and data types in sql server
SQL
2 votes200 views1 answer
Mysql sysdate - 1 day
SQL
0 vote218 views1 answer
Test database for sql
SQL
0 vote205 views1 answer
Addition of 2 column value in mysql
SQL
1 vote169 views1 answer
Unique vs distinct sql
SQL