/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

2 votes383 views1 answer
Q operator in oracle
SQL
1 vote363 views1 answer
Mysql return text after a final full stop
SQL
2 votes375 views6 answers
Mysql change timezone
SQL
0 vote339 views1 answer
Soql last week
SQL
0 vote360 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote328 views1 answer
Index a database column sql
SQL
0 vote347 views1 answer
User defined variables in sql
SQL
0 vote335 views1 answer
Renommer schema sql
SQL
0 vote289 views1 answer
Sqlalchemy existing database
SQL
1 vote288 views1 answer
Prevent duplicate rows in postgres
SQL

Share