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
22281 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 jobs use sql?

986

what is a view? : Sql dba

1104

How insert into statements in sql?

1081

How does postgresql compare to mysql?

1039

What is the difference between view and stored procedure?

962

what does the t-sql command ident_current does? : Transact sql

988

What is mutating sql table?

1117

Is left join inner or outer?

1024

is it possible to pass an object or table to a procedure as an argument?

1137

What pl/sql package consists of?

1090

What are character functions in sql?

943

Is sql developer case sensitive?

1005

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4292

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1241

What is record in pl sql?

1090