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 do I make my sql query run faster?

939

What is number function in sql?

962

Is sql open source?

970

what is the difference between $message and $$message? : Sql dba

995

What is db journal file?

1052

Why self join is used in sql?

968

Does sql support programming?

1064

Do we need to create index on primary key?

921

What is data definition language?

1088

Is it possible for a table to have more than one foreign key?

1028

What programs use sql?

996

What is trigger in flip flop?

1007

Describe types of sql statements?

1052

What is the difference between sql and t sql?

1029

what is a materialized view? : Sql dba

1058