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
22730 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 is the difference between a having clause and a where clause? : Sql dba

1159

how to calculate the difference between two dates? : Sql dba

1115

what tools available for managing mysql server? : Sql dba

1132

What is the difference between clustered and non-clustered indexes?

1132

What is the advantage of index in sql?

1020

Can we use ddl commands in pl sql?

1235

What is a composite primary key?

1142

what is the difference between delete and truncate statement in sql? : Sql dba

1349

what is a trigger? : Sql dba

1095

what is a unique key ? : Sql dba

1151

What are the types of triggers in sql?

1144

Is pl sql a programming language?

1045

what is bcp? When does it used? : Sql dba

1030

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1086

Define select, insert, create, delete, update, drop keywords

1094