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 log shipping? : Sql dba

1074

what is a join? : Sql dba

977

what is an index? : Sql dba

949

Does sap use sql?

939

What is relationship? How many types of relationship are there?

1094

Which is faster joins or subqueries?

943

Why functions are used in sql?

952

Can triggers stop a dml statement from executing on a table?

1043

How do I add a database to sql?

1085

what are the different index configurations a table can have? : Sql dba

951

What is foreign key and example?

902

What does the hierarchical profiler does?

1020

What is database white box testing and black box testing?

1062

How do you remove duplicate records from a table?

901

what is the difference between primary key and unique key? : Sql dba

991