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 / naren
select count(*) from t1 where a is null or b is null or c is
null or d is null
Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
What is record type in pl sql?
how can we find the number of rows in a table using mysql? : Sql dba
What is sql data?
What are the indexing methods?
Which is better stored procedure or query?
How would you pass hints to the sql processor?
How do I send sql query results to excel?
What jobs use sql?
What are user defined functions?
What can you do with pl sql?
What are the different set operators available in sql?
How do I delete a trigger?
What are system versioned tables?
How can we optimize a sql query?
Explain 3 basic parts of a trigger.