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

how is myisam table stored? : Sql dba

1000

What are sql constraints?

1128

Is pl sql different from sql?

938

how to return query output in html format? : Sql dba

1023

What are sql objects?

1015

What are the various levels of constraints?

1061

Do we need commit after truncate?

1034

What are the most important characteristics of pl/sql?

1080

How to download oracle sql developer?

1058

what are the advantages of sql ? : Sql dba

1000

what is oltp (online transaction processing)? : Sql dba

1016

What is the difference between sql, mysql and sql server?

1016

Can a view be mutating? If yes, then how?

963

Can we use rowid as primary key?

944

What is assignment operator in pl sql?

970