hi naren thank for your ans. but here i am asking total count of null re

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 / sreenu

14 Answers
21787 Views
iGate, Wipro, I also Faced
E-Mail Answers

Answer Posted / sreenu

hi naren thank for your ans.

but here i am asking total count of null records. means how
many null values are there.

see above table having 4 null values. i want display "4".

please tell me sql query

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is delete command in sql?

1066

What are the different types of tables in sql?

947

What is a field in a database?

1024

How to disable a trigger name update_salary?

1216

What are the constraints available in sql?

1013

What is the difference between syntax error and runtime error?

1086

What is pl sql script?

989

What is the difference between left outer join and left join?

960

Does mysql_real_escape_string prevent sql injection?

916

What is the current version of postgresql?

1024

What is execution plan in sql?

997

What is equi join in sql?

1027

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1084

How to handle bulk data?

1280

What does an inner join do?

1116