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
22266 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 sql key?

998

Explain the uses of a database trigger?

1044

How to run pl sql program in mysql?

1025

Which sql statement is used to return only different values?

1008

What is an exception in pl/sql?

1091

Do we need to create index on primary key?

929

what is a record in a database ? : Sql dba

1066

What is the location of pre_defined_functions.

1166

What is sap sql anywhere?

1084

Which sql statement is used to delete data from a database?

963

What are the parts of a sql statement?

1090

Mention what is the plv (pl/vision) package offers?

1107

How we can update the view?

1052

What is a null value?

1150

How do you write a complex sql query?

1088