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 to convert dates to character strings? : Sql dba

1070

Which one is better subquery or joins?

1008

What is record data type?

858

How do you copy a table in sql?

1013

Why is sql important?

1026

How to create your own reports in sql developer?

973

What are types of indexes in sql?

1006

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1072

write an sql query to find names of employee start with 'a'? : Sql dba

965

How can we avoid duplicating records in a query?

922

What is a pl/sql block?

1111

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

970

How do I start sql profiler?

941

Is natural join and inner join same?

853

How many times can we commit in a loop?

956