SELECT a_null + b_null + c_null + d_null FROM (SELECT COUNT (DECODE (a,

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

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

Answer Posted / abinash_mishra

SELECT a_null + b_null + c_null + d_null
FROM (SELECT COUNT (DECODE (a, NULL, 1, NULL)) a_null,
COUNT (DECODE (b, NULL, 1, NULL)) b_null,
COUNT (DECODE (c, NULL, 1, NULL)) c_null,
COUNT (DECODE (d, NULL, 1, NULL)) d_null
FROM t_null);

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of indexes?

1010

Can we use the cursor's to create the collection in PL/SQL?

1027

Explain what is a subquery ?

1188

What are schema-level triggers?

1102

Why do we need cursors in pl sql?

1081

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

What is a sql trace file?

1028

How can I speed up sql query?

962

What are secondary keys?

971

Can we create index on primary key?

969

What are pl/sql packages?

1102

what are aggregate and scalar functions? : Sql dba

1057

what is data control language? : Sql dba

1026

What are reports usually used for?

1023

What is #table in sql?

1098