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
21666 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

Is primary key a clustered index?

914

Is nosql relational?

896

What is the largest value that can be stored in a byte data field?

958

What is the difference between a subquery and a join?

1014

How does pl sql work?

915

What is a database event trigger?

1086

Explain the uses of a database trigger?

985

What is nosql vs sql?

1123

How do I save a stored procedure?

951

what is the functionality of the function htmlentities? : Sql dba

894

How to use transactions efficiently : transact sql

993

What is date functions?

964

What is nosql example?

971

What is delete command in sql?

1053

What is embedded sql what are its advantages?

962