SELECT A+B+C+D FROM ( select count(decode(A,null,1)) A, COUNT(DECODE (

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

14 Answers
22181 Views
iGate, Wipro, I also Faced
E-Mail Answers

Answer Posted / mani

SELECT A+B+C+D FROM
( select
count(decode(A,null,1)) A,
COUNT(DECODE (B,null,1))B,
COUNT(DECODE (C,null,1))C,
COUNT(DECODE(D,null,1)) D
from PRACTICE2);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of nvl function?

1192

how to do backup entire database? : Transact sql

1140

what is transaction? : Sql dba

1003

What is sequence in sql?

997

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1054

Explain the working of foreign key?

1060

How do I order columns in sql?

1000

Explain what is a subquery ?

1184

What is a .db file?

984

What schema means?

885

How do I add a primary key to a table?

1040

How do you use a while loop in pl sql?

1006

what is innodb? : Sql dba

1097

What are the different types of sql commands?

1120

Does postgresql run on the cloud?

1140