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

How many types of tables are there?

517


what is csv? : Sql dba

584


What is data type in database?

556


Explain the working of foreign key?

555


What is minus?

557






What does sign mean sql?

581


How to select random rows from a table?

533


Can we call dml statement in function?

551


what are dynamic queries in t-sql? : Transact sql

567


How do I order by ascending in sql?

544


What is normalization in sql?

533


Explain what is sql?

615


Is stored procedure faster than query?

571


How can I delete duplicate rows?

571


Can we use distinct and group by together?

600