select sum(decode(a,null,1))+ sum(decode(b,null,1))+ sum(decode(c,null,1)

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 / kishore vakiti

Answer Posted / kishore vakiti

select sum(decode(a,null,1))+
sum(decode(b,null,1))+
sum(decode(c,null,1))+
sum(decode(d,null,1)) tot_nulls from <TAB-NAME>;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does sql view stored data?

548

How do I view a procedure in sql?

563

How do I debug a stored procedure?

645

How does a self join work?

530

What are the benefits of pl sql?

544

What are types of indexes in sql?

554

How does join work in sql?

569

What is trigger price?

562

Is it possible to update views?

552

what are the different type of normalization? : Sql dba

566

What is the importance of sqlcode and sqlerrm?

870

What are the usages of sql?

579

Can we enter data in a table in design view?

530

how to rename an existing column in a table? : Sql dba

521

how to get a list of indexes of an existing table? : Sql dba

535