/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

13 votes132 views2 answers
Get date from now() mysql
SQL
1 vote133 views1 answer
Top 10 rows in mysql
SQL
0 vote129 views1 answer
Ignore case in string sql
SQL
3 votes138 views3 answers
Raw select laravel
SQL
18 votes126 views2 answers
Sql inner join
SQL
0 vote79 views1 answer
Oracle sql developer script output limit
SQL
9 votes133 views4 answers
How to alter table column name in mysql
SQL
1 vote87 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote142 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote122 views1 answer
Myswql show full processlist
SQL