select (count(decode(A,null,1)) + count(decode (B,null,1)) + count(decode(C

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

Answer Posted / gaurav

select (count(decode(A,null,1)) + count(decode (B,null,1)) + count(decode(C,null,1) + count(decode(D,null,1))) null_count
from T

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

List out the acid properties and explain?

1018

How do I start sql from command line?

1082

what are all the common sql function? : Sql dba

1106

Why indexing is needed?

1046

What is update query?

1035

What are the indexing methods?

1099

What is informix sql?

1032

What is the difference between left join and right join?

990

What is sap sql?

1030

how to install mysql? : Sql dba

1161

how are mysql timestamps seen to a user? : Sql dba

1198

How many tables can a sql database have?

1029

explain advantages of innodb over myisam. : Sql dba

1176

How do I add a primary key to a table?

1085

What is tuple in sql?

1143