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 pl/sql table? Why is it used?

1051

What is the use of sqldataadapter?

979

How to run sql functions in pl/sql?

1059

Is left join and outer join same?

1076

How can you fetch first 5 characters of the string?

1018

What are all the common sql functions?

1036

What is a loop in sql?

990

How can you save or place your msg in a table?

1004

Is sql a scripting language?

1023

What is the purpose of cursors in pl/sql?

1138

how to extract a unit value from a date and time? : Sql dba

998

How are functions and procedures called in PL/SQL?

1239

How many types of indexes are there in sql?

986

What is a data definition language?

1144

tell me about various levels of constraint. : Sql dba

1036