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
21629 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 the difference between clustered and a non-clustered index? : Sql dba

976

how can we repair a mysql table? : Sql dba

911

What is the difference between stored procedure and view?

962

What is the maximum size of sqlite database?

1039

Can we insert data in view?

886

What are keys in sql?

939

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

952

Mention what plvcmt and plvrb does in pl/sql?

1061

Can you do multiple joins in sql?

969

What is a heap in sql?

989

Why do we create views in sql?

1049

What is function and procedure?

980

what is try_catch block in procedure

1653

What is the least restrictive isolation level? : Transact sql

992

How many types of indexes are there in sql?

932