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

What is cursor in pl sql with examples?

693

Describe sql comments?

745

How can I delete duplicate rows?

752

Does user triggers have entry for trigger with compilation errors?

811

What is a schema sql?

775

What is the difference between drop and truncate commands?

735

What is count * in sql?

754

What is anonymous block in sql?

858

what tools available for managing mysql server? : Sql dba

764

What is oracle and pl sql?

853

What are the types of views in sql?

780

Is left join faster than join?

771

What are the types of keys?

693

What is auto increment?

751

How do I truncate a word?

723