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 is pl sql needed?

503

What is the sql case statement?

568

Is nosql relational?

544

When is the update_statistics command used?

568

Can we use view in stored procedure?

506

When is the explicit cursor used ?

588

What is a trigger in sql?

634

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

531

Can there be 2 primary keys in a table?

553

How much does sql certification cost?

542

What is scalar function in sql?

527

What are the different types of sql commands?

595

What is a nested table in word?

529

What is trigger in pl sql?

555

How many disk partitions should I have?

545