/SQL/Get count of null in column sql

Get count of null in column sql

Sql count null values in all columns

SELECT sum(CASE WHEN column_A IS NULL THEN 1 ELSE 0 END) A,
       sum(CASE WHEN column_B IS NULL THEN 1 ELSE 0 END) B
FROM my_table;

0

How to count null values in sql

SELECT COUNT(1) FROM my_table WHERE my_column IS NULL;

0

Get count of null in column sql

select sum(case when a is null then 1 else 0 end) count_nulls
     , count(a) count_not_nulls 
  from us;

0

Source: stackoverflow.com

Similar codes

16 votes184 views1 answer
Sqlserver add column to table
SQL
3 votes232 views1 answer
Export postgres database linux
SQL
3 votes185 views2 answers
Postgresql remove not null constraint
SQL
1 vote194 views1 answer
How to group by month using sql server
SQL
5 votes197 views2 answers
To date oracle
SQL
0 vote230 views1 answer
Sql describe
SQL
2 votes330 views1 answer
How to create sql database
SQL
4 votes187 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
6 votes207 views2 answers
Mysql timestamp to date
SQL
3 votes187 views3 answers
Remove all spaces from string sql
SQL

Share