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

what is the difference between delete and truncate statement in sql? : Sql dba

1127

What is sql query limit?

911

What is the difference between function and procedure in pl/sql?

1014

What is function and procedure in pl sql?

970

Why truncate is used in sql?

936

What is a data definition language?

1027

how to fetch alternate records from a table? : Sql dba

1051

Why is sql*loader direct path so fast?

1053

Does google use sql?

912

Is inner join faster than left join?

1124

How can you load microsoft excel data into oracle? : aql loader

1128

Can we use join in subquery?

1022

How to fix oracle error ora-00942: table or view does not exist

955

What is the left table in sql?

914

What does the hierarchical profiler does?

1003