select count(decode(val,null,1)) all_null

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 / kavitha neditunta

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

Answer Posted / kavitha neditunta

select
count(decode(val,null,1)) all_null_val
FROM
(select * from t1) UNPIVOT INCLUDE NULLS ( VAL for(
all_null_val) in ( a as 'a', b as 'b', c as 'c', d as 'd') )

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 the difference between Union and Union all. Which is faster.

1441

what is clause? : Sql dba

1118

What is the difference between a procedure and a function?

1216

Can a trigger call a stored procedure?

1130

Why is a trigger used?

994

what are date and time data types? : Sql dba

1028

What is t sql in sql server?

1132

How do I count duplicates in sql?

1178

How to run sql statements with oracle sql developer?

1123

what are string data types? : Sql dba

1093

Explain the structure of pl/sql in brief.

1142

What is the difference between a primary key and a clustered index?

1037

Why indexing is needed?

1046

Are sql connections encrypted?

1089

What is the purpose of my sql?

1014