/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

1 vote232 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote277 views1 answer
How to find unique element in sql
SQL
6 votes251 views4 answers
Mysql get random row
SQL
0 vote210 views1 answer
Sql examples from your work
SQL
0 vote212 views1 answer
Postgres add prefix to primary key
SQL
7 votes258 views2 answers
Phpmyadmin change password
SQL
3 votes236 views1 answer
RENAME table pl sql
SQL
0 vote239 views1 answer
To_date sql
SQL
1 vote226 views1 answer
Oracle finding duplicate records
SQL
1 vote255 views2 answers
Postgresql check privileges on schema
SQL

Share