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 are the different sql languages?

1031

explain about mysql and its features. : Sql dba

1013

Can function return multiple values in sql?

1050

What is data control language (dcl)?

1131

What is sqlerrd?

966

what are the drivers in mysql? : Sql dba

1015

What are field types?

996

when MSQL8.0 is in market

2072

What are sql constraints?

1172

What are the properties of a transaction?

1128

What is the maximum size of sqlite database?

1101

how to escape special characters in sql statements? : Sql dba

1033

What is basic structure of pl sql?

1066

Advantages and disadvantages of stored procedure?

1119

Is coalesce faster than isnull?

962