/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

0 vote197 views1 answer
Oracle sql add column auto generated value
SQL
1 vote186 views1 answer
Sql how to duplicate a table
SQL
1 vote186 views1 answer
Mariadb case switch
SQL
12 votes198 views4 answers
How to check mysql version ubuntu
SQL
0 vote181 views1 answer
Mysql set column equal to another automatic
SQL
3 votes231 views2 answers
How to View column names of a table in SQL
SQL
12 votes245 views10 answers
Google
SQL
10 votes209 views2 answers
Select nextval from sequence oracle
SQL
0 vote232 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote212 views1 answer
Oracle index partition
SQL

Share