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 are the advantages of mysql in comparison to oracle? : Sql dba

998

What is normalization in sql?

1009

Can a table contain multiple primary key’s?

1094

What is before trigger?

999

Do foreign keys improve performance?

1019

Does inner join remove duplicates?

936

What is difference between joins and union?

1117

What is a unique constraint?

1065

List the different type of joins?

1059

What is sql architecture?

1045

What is row_number () in sql?

978

Mention what are different methods to trace the pl/sql code?

1199

Can we insert delete data in view?

947

Can you have more than one key in a database?

931

What is a sql schema used for?

1092