/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

5 votes226 views1 answer
Sql select ciunt
SQL
0 vote228 views1 answer
Oracle decode
SQL
1 vote221 views1 answer
Get last week data in mysql
SQL
1 vote183 views1 answer
Unique vs distinct sql
SQL
1 vote214 views1 answer
Sql server kill all connections
SQL
0 vote216 views1 answer
Enable Rabbitmq management plugin
SQL
2 votes213 views1 answer
Sql server conection string
SQL
10 votes237 views2 answers
Doublon sql
SQL
0 vote225 views1 answer
Distinct data types in a table sql query
SQL
1 vote242 views2 answers
This month mysql where
SQL

Share