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 case function?

1034

How can you save or place your msg in a table?

999

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1185

Explain what is a field in a database and record in a database?

1093

How do I view a sql trace file?

1022

What is program debugging?

1240

When sql appeared?

1086

What are the types of queries in sql?

1080

Does sql*plus have a pl/sql engine?

1067

What has stored procedures in sql?

1062

What is file based approach?

936

How can we make an if statement within a select statement?

1006

Does db2 use sql?

940

How do I delete a trigger?

961

what is timestamp in mysql? : Sql dba

1069