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 you go back in sql?

940

Are dml statements autocommit?

984

Should I use mbr or gpt?

946

How to display the current date in sql?

1008

Is big data nosql?

886

What is sql prepared statement?

937

Why do we use subquery?

943

What are the differences between implicit and explicit cursors?

1002

What is a variable in sql?

950

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

917

What are the basic sql commands?

1037

How to rename a column in the output of sql query?

1000

Why use truncate instead of delete?

960

Define commit, rollback and savepoint?

977

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

937