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

Name the different types of indexes in sql and define them.

1094

what are different types of collation sensitivity? : Sql dba

1040

What is difference between inner join and cross join?

922

What does seeding a database mean?

905

How many types of index are there?

991

how can you create an empty table from an existing table? : Sql dba

1096

What is the difference between microsoft access and sql?

978

What are the properties of a transaction?

1086

What is oracle sql developer?

1006

What is difference between hql and sql?

1009

what are the different type of normalization? : Sql dba

980

What is the sql query to display the current date?

1012

How do I order columns in sql?

930

Is left join same as inner join?

1042

Explain the difference between 'between' & 'and' operators in sql

963