select count(*) from t1 where a is null or b is null or c is null or d is

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

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

Answer Posted / naren

select count(*) from t1 where a is null or b is null or c is
null or d is null

Is This Answer Correct ?

26 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a data manipulation language?

1078

how to rename an existing column in a table? : Sql dba

1084

What is transaction control language (tcl)?

1187

What does rownum mean in sql?

1091

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2070

What are properties of the transaction?

1046

What is Materialized View? In What Scenario we Use Materialized View?

9622

What is multiple columns?

1120

What is the difference between inner join and left join?

1041

Why indexing is needed?

1046

What are the types of keys?

1067

How to use boolean type in select statement?

1140

What are the benefits of pl/sql packages?

1161

What is Histogram?

1611

What is a boolean in sql?

1025