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
22733 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 does stand for in sql?

1026

Does view contain data?

1084

What is where clause in sql?

1088

In a distributed database system, can we execute two queries simultaneously?

1155

How do you update sql?

1038

Can a foreign key be a duplicate?

966

Explain mutating table error.

1263

What do you think about pl/sql?

1126

Why we use sql profiler?

1023

How to use boolean type in select statement?

1139

Can you selectively load only those records that you need? : aql loader

1095

how many triggers are allowed in mysql table? : Sql dba

1107

How can you load multi line records? : aql loader

1126

How to assign sql query results to pl sql variables?

1149

What does the sign mean in sql?

1049