/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 vote118 views1 answer
Psql generate id in existing database
SQL
0 vote126 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote111 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote133 views1 answer
How to check foreign key constraint in sql
SQL
1 vote131 views2 answers
Drop table if exists test
SQL
1 vote107 views1 answer
Show table columns
SQL
0 vote109 views1 answer
Oracle current timestamp insert statement
SQL
0 vote128 views1 answer
Sql server insert inner join
SQL
1 vote106 views1 answer
How to open closed port mysql in ubuntu
SQL
3 votes110 views2 answers
Truncate all tables
SQL