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

Explain how to use transactions efficiently : transact sql

715

How do I run a sql query in pgadmin 4?

717

What is the least restrictive isolation level? : Transact sql

763

what is recursive stored procedure? : Sql dba

714

What is schema in sql?

683

Can we join two tables without common column?

697

What does the acronym acid stand for in database management?

775

Is vs as in pl sql?

670

what are null values? : Sql dba

706

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

809

what is the syntax used for partition in tsql? : Transact sql

727

What is full join in sql?

713

What is the use of %rowtype?

743

How will you distinguish a global variable with a local variable in pl/sql?

838

What is the difference between function, procedure and package in pl/sql?

763