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 do I tune a sql query?

514

Can we group by two columns in sql?

507

What is an exception in PL/SQL? What are the two types of exceptions?

629

How do you copy a table in sql?

563

Define concurrency control. : Transact sql

587

What are secondary keys?

561

How can we optimize a sql query?

577

Do stored procedures prevent sql injection?

550

What is equi join in sql?

612

What does bitemporal mean?

599

What are joins in sql?

541

What is the main difference between sql and pl/sql?

566

What is the difference between cluster and non-cluster index?

620

What is left join example?

504

is it possible to pass an object or table to a procedure as an argument?

576