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

How do I count rows in sql query?

986

explain access control lists. : Sql dba

995

How can we make an if statement within a select statement?

1006

What are the types of triggers in sql?

1088

Can we insert data in view?

955

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1065

How do I sort a table in sql?

1038

How do I view a view in sql?

948

What is snowflake sql?

1069

How do you modify a column in sql?

991

Explain alias in sql?

1039

how to drop an existing table in mysql? : Sql dba

1042

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1144

What does select * from mean in sql?

3218

Is sqlexception checked or unchecked?

964