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 is record type in pl sql?

548

how can we find the number of rows in a table using mysql? : Sql dba

586

What is sql data?

552

What are the indexing methods?

575

Which is better stored procedure or query?

548

How would you pass hints to the sql processor?

530

How do I send sql query results to excel?

581

What jobs use sql?

531

What are user defined functions?

579

What can you do with pl sql?

566

What are the different set operators available in sql?

565

How do I delete a trigger?

545

What are system versioned tables?

553

How can we optimize a sql query?

575

Explain 3 basic parts of a trigger.

841