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

How do I run sql profiler?

1118

Explain constraints in sql?

1088

what is a composite primary key ? : Sql dba

1095

Can we insert in sql function?

1142

What is database sql?

1097

What are the sql versions?

999

What is the difference between python and sql?

1054

Which function is used to return remainder in a division operator in sql?

1201

Which one is better subquery or joins?

1115

What is the difference between the conventional and direct path loader? : aql loader

1193

What is the difference between in and between in sql?

1109

What is the difference between join and natural join?

984

What are the two types of cursors in pl sql?

1123

What is the difference between inner join and outer join?

1040

what is the difference between char_length and length? : Sql dba

1110