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

Which command is used to call a stored procedure?

495

What is set serveroutput on in pl sql?

565

What is the advantage of nosql?

520

what are the type of locks ? : Sql dba

523

What is cross join sql?

492

What are the advantages of pl sql?

596

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1704

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

668

How do you select unique values in sql?

494

How do I run a script in sql developer?

489

Enlist the data types that can be used in pl/sql?

568

Can there be more than one function with a similar name in a pl/sql block?

539

What is orm in sql?

533

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

500

What are the 3 modes of parameter?

675