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.

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 offset and limit in sql?

744


What are the advantages of sql?

777


State some properties of relational databases?

762


Why cross join is used?

825


How does stored procedure reduce network traffic?

732






Is not null in sql?

732


What is the sql query to display the current date?

760


Can we insert delete data in view?

730


what is the difference between join and union? : Sql dba

720


how is myisam table stored? : Sql dba

782


Define a temp table?

755


What is exit statement?

744


How do you identify a primary key?

815


Write a sql query to find the names of employees that begin with ‘a’?

743


List the ways to get the count of records in a table?

655