select count(decode(a,null,1)),count(decode(b,null,1)),count(decode(c,null

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 / naren

Answer Posted / naren

select
count(decode(a,null,1)),count(decode(b,null,1)),count(decode(c,null,1)),count(decode(d,null,1))
from t1

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How does cross join work?

960

Why is theta join required?

1145

Explain aggregate functions are available there in sql?

1007

How to read xml file in oracle pl sql?

913

How do you bind variables in pl sql?

1097

Why is sql better than hql?

992

Explain the purpose of %type and %rowtype data types with the example?

995

What is cross join example?

1007

Why do we create stored procedures & functions in pl/sql and how are they different?

950

Are views faster than queries?

992

what is foreign key? : Sql dba

1050

how is myisam table stored? : Sql dba

1056

Does view contain data?

1037

What are inner and outer joins examples of both?

962

Where not exists in sql?

979