select sum(case when A is null then 1 when B is null then 1 when C is nul

i have table T!.

A B C D
NULL 1 2 3
4 NULL 5 6
7 8 NULL 9
10 11 12 NULL.

I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

Question Posted / ash

Answer Posted / ash

select sum(case when A is null then 1 when B is null then 1
when C is null then 1 when D is null then 1 else 0 end)as
count_null from table T

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a natural join sql?

977

what happens if you no create privilege in a database? : Sql dba

1001

what is the difference between truncate and delete statement? : Transact sql

1064

what are the different type of sql's statements ? : Sql dba

926

What is the difference between partitioning and sharding?

1008

what are the differences between char and nchar? : Sql dba

1115

when is the use of update_statistics command? : Sql dba

1049

What do you understand by exception handling in pl/sql?

1035

List different type of expressions with the example.

935

Inline the values in PL/SQL, what does it mean.?

1229

What is a relationship and what are they?

1153

What is dml and ddl?

959

Difference between table function and pipelined function?

1027

What is column?

992

What is pl sql quora?

1167