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

Differentiate between sga and pga.

1088

What is the difference between left outer join and left join?

943

how many triggers are allowed in mysql table? : Sql dba

995

What is pl sql in dbms?

900

What is a sql*loader control file?

1159

How does stored procedure reduce network traffic?

966

what are set operators in sql? : Sql dba

983

How do I truncate a word?

997

How to select unique records from a table?

999

How do I start pl sql?

895

Explain the steps needed to create the scheduled job?

966

How do temporal tables work?

907

What is acid property in a database?

973

What are different methods to trace the pl/sql code?

1047

What is a nested table in word?

909