/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 vote280 views1 answer
Where field is null sql knex
SQL
4 votes322 views3 answers
Postgres drop all tables
SQL
0 vote287 views1 answer
Mssql + bit + in python orm
SQL
0 vote278 views3 answers
Osx stop mysql service
SQL
1 vote305 views1 answer
How to delay stored procedure execution in sql server
SQL
4 votes274 views2 answers
Sql table
SQL
1 vote276 views1 answer
Mysql stop password policy
SQL
8 votes285 views5 answers
Grant permission in postgres
SQL
0 vote287 views1 answer
How to search query in python3 sqlite3
SQL
0 vote264 views1 answer
Resulting Query
SQL