/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

3 votes183 views1 answer
What is having clause
SQL
0 vote189 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote183 views1 answer
Get count by weekly pivot table sql server
SQL
13 votes214 views2 answers
Sql online compiler
SQL
0 vote188 views1 answer
Case insensitive sql
SQL
0 vote193 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote184 views1 answer
Stuff in sql server
SQL
0 vote244 views1 answer
How to find unique element in sql
SQL
0 vote207 views1 answer
Default column value in sql same as another column laravel
SQL
2 votes181 views1 answer
Update with join sql server
SQL