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

how to decrement dates by 1 in mysql? : Sql dba

970

What is information schema in sql?

1017

Can we use insert statement in function?

942

What is substitution variable?

1003

What is data type in sql?

923

How do I filter in sql profiler?

949

Explain how can you save or place your msg in a table?

985

how to calculate the difference between two dates? : Sql dba

996

What is sql deadlock?

1050

What are the different ways to optimize a sql query?

891

What is scalar function in sql?

979

Is sql a backend?

968

How to select 10 records from a table?

1099

Define tables and fields in a database

1081

What does an inner join do?

1093