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
21630 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 forward declaration in pl sql?

1005

what is not null constraint? : Sql dba

963

How do I trace sql profiler?

919

Name three sql operations that perform a sort.

957

What does pragma mean?

967

What jobs use sql?

921

What are aggregate and scalar functions?

973

What is cursor and why it is required?

1105

what are the different functions in sorting an array? : Sql dba

967

Can we commit in trigger?

920

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1030

Where is pl sql used?

903

What is the meaning of disabling a trigger?

1108

What is procedure and function?

918