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 use of friend function? : Sql dba

543

What is natural join in sql?

537

How to place comments in pl/sql?

605

How do you use join?

524

Explain mutating table error.

649

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

601

What is sequence in sql?

506

How do you add a column to a table?

603

How do I find sql profiler?

520

Why do we need cursor in pl sql?

651

what are rollup and cube in t-sql? : Transact sql

661

What is rtm stands for?

585

Is sql injection illegal?

597

what is subquery? : Sql dba

572

What is Collation Sensitivity ? What are the various type ?

501