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

What is the difference between an inner join and an outer join?

516

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

603

What is the difference between cross join and natural join?

566

How do I pipe the output of one isql to another?

532

How many disk partitions should I have?

553

what are the security recommendations while using mysql? : Sql dba

581

What is union, minus and interact commands?

750

What is the usage of when clause in trigger?

569

How do I debug a stored procedure?

629

How many parts of a pl sql block are optional?

520

Which table is left in left join?

525

What is mutating trigger?

585

What is the use of index in sql?

559

how to get @@error and @@rowcount at the same time? : Sql dba

529

how to use myisamchk to check or repair myisam tables? : Sql dba

509