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

How many sectors are in a partition?

1076

What is count * in sql?

993

How would you convert date into julian date format?

1000

What is join view in sql?

944

Why use triggers in sql?

953

What is sql data?

988

Is sql similar to python?

968

what does the t-sql command ident_incr does? : Transact sql

1072

How can I get the number of records affected by a stored procedure?

1058

What are reports usually used for?

1019

what is subquery? : Sql dba

1126

what is sp_pkeys? : Transact sql

1149

what is text? : Sql dba

1065

Can we create table in function?

960

Enlist some predefined exceptions?

1053