select a1+b1+c1+d1 from (select count(case when a='null' then 1

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 / ramesh

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

Answer Posted / ramesh

select a1+b1+c1+d1 from
(select count(case when a='null' then 1 end) a1,
count(case when b='null' then 1 end) b1,
count( case when c='null' then 1 end) c1,
count(case when d='null' then 1 end) d1 from t1)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

1031

What is an inner join sql?

1097

Is time a data type in sql?

960

What is trigger in sql? Explain

1039

what is subquery? : Sql dba

1187

what is cross join? : Sql dba

1046

When is a declare statement required?

1193

how to select unique records from a table? : Sql dba

1173

What is using in sql?

1139

What are the types of join and explain each?

1100

how is myisam table stored? : Sql dba

1097

How many commands are there in sql?

1084

Can a procedure in a package be overloaded?

1099

What is a data definition language?

1195

who introduced sql?

1070