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 to use distinct and count in sql query? Explain

955

How many types of triggers are there in pl sql?

1006

What is rank function in sql?

957

How many joins in sql?

944

How many types of normalization are there?

894

How to run sql functions in pl/sql?

986

what is a stored procedure? : Sql dba

1049

what is a relationship and what are they? : Sql dba

1018

what is the difference between a having clause and a where clause? : Sql dba

1003

Which is faster subquery or join?

1139

Enlist the advantages of sql.

935

Define commit, rollback and savepoint?

976

What is meant by truncate in sql?

1002

what is bcp? When does it used? : Sql dba

932

In what condition is it good to disable a trigger?

967