/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

11 votes285 views4 answers
MYSQL LOGIN
SQL
7 votes280 views1 answer
Oracle pagination query offset
SQL
0 vote304 views1 answer
Sql quary intervewi question
SQL
0 vote285 views1 answer
Change database name psql 8
SQL
0 vote257 views1 answer
How to save data in database in mysql node
SQL
14 votes322 views6 answers
Finding duplicate rows mysql
SQL
0 vote297 views1 answer
Postgres change the name of schema
SQL
0 vote304 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote263 views1 answer
Json not contains mysql
SQL
0 vote292 views4 answers
Creating a comment and reply system PHP and MySQL
SQL