select sum(nvl2(col1,0,1)+sum(nvl2(col2,0,1)+<...as many columns we hav

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 / ankesh

Answer Posted / ankesh

select sum(nvl2(col1,0,1)+sum(nvl2(col2,0,1)+<...as many
columns we have > from <table name>

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I tune a sql query?

1043

What is insert command in sql?

1193

Which tcp/ip port does sql server run?

1070

What are the different sql commands?

1130

what are date and time data types? : Sql dba

1028

What is scope and visibility in PL/SQL?

1291

How do I quit sql?

1007

what is foreign key? : Sql dba

1110

Can we call a function containing dml statements in a select query?

1025

Explain the methods used to protect source code of pl/sql.

1074

How do I send sql query results to excel?

1113

What are the parameter modes supported by pl/sql?

1154

Can a commit statement be executed as part of a trigger?

1105

how to include character strings in sql statements? : Sql dba

1141

Is left join inner or outer by default?

1074