/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 vote325 views1 answer
Day of the week sqlite
SQL
0 vote332 views1 answer
How to get data from 2 database
SQL
0 vote316 views1 answer
Postgresql conectar
SQL
1 vote274 views1 answer
Into sql
SQL
0 vote314 views1 answer
Oracle character index
SQL
0 vote308 views1 answer
Soql more than today
SQL
0 vote328 views1 answer
Mysql readable output
SQL
10 votes328 views5 answers
Between keyword in sql
SQL
0 vote307 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote331 views1 answer
Difference between 2 query results sql server
SQL