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
22204 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

How do you truncate?

902

Is nosql relational?

938

Where is sql database stored?

979

what are all the different types of indexes? : Sql dba

1046

What is %rowtype in pl sql?

987

What are the subsets of sql?

1130

How do I find sql profiler?

933

Which one is better subquery or joins?

1058

What is cursor and its types?

1063

What is a behavioral trigger?

970

Is record in oracle pl sql?

958

what is the syntax used for partition in tsql? : Transact sql

1014

what is meant by urlencode and urldocode? : Sql dba

1172

How to write pl sql program in mysql command prompt?

1089

Can we commit in trigger?

968