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

What are the advantages of indexing?

728

How does join work in sql?

727

What is right join in sql?

744

Can there be more than one function with a similar name in a pl/sql block?

746

What are the different ways to optimize a sql query?

678

What is the difference between inner join and natural join?

703

Are stored procedures faster than queries?

696

How bulk collect improves performance?

742

What is a primary key example?

695

Is big data nosql?

692

Who developed sql?

756

What is clustered and nonclustered index in sql?

696

How to run pl sql program in mysql?

681

How do I copy a table in sql?

695

what is union, minus and interact commands? : Sql dba

860