/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 vote356 views1 answer
Show tables in cassandra cql
SQL
0 vote362 views1 answer
Mysql record group by created date count
SQL
10 votes327 views1 answer
Oracle all_dependencies
SQL
0 vote341 views1 answer
Insert or update sql query
SQL
0 vote323 views1 answer
Truncate a table then insert data
SQL
2 votes324 views1 answer
Copy all values of a column to another column in sql in same table
SQL
8 votes348 views1 answer
Racle create auto increment column
SQL
-1 vote321 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote398 views1 answer
Selecting specific day in colum sql
SQL
20 votes362 views1 answer
Get all table name in sql through php
SQL