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

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

Please Help Members By Posting Answers For Below Questions

Why do we use subquery?

1014

How do you pronounce sql?

1010

What is data definition language?

1092

Explain 3 basic parts of a trigger.

1323

Enlist the data types that can be used in pl/sql?

1073

What is set serveroutput on in pl sql?

1296

Why should I use postgresql?

1014

What is a full join?

983

What is sql catalog?

1018

What does trigger mean in slang?

1055

What is the difference between a primary key and a clustered index?

993

What is #table in sql?

1098

What is a join query?

962

What is mutating error?

965

What is bitemporal narrowing?

1308