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 / ash
select sum(case when A is null then 1 when B is null then 1
when C is null then 1 when D is null then 1 else 0 end)as
count_null from table T
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between view and stored procedure?
explain the delete statements in sql
When do we use triggers?
When are we going to use truncate and delete?
What is group by in sql?
Does mysql support pl sql?
How do I install microsoft sql?
What is difference between procedure and trigger?
Can a varchar be a primary key?
What is a constraint? Tell me about its various levels.
explain about mysql and its features. : Sql dba
What are joins in sql?
What is sql in oracle?
What are stored procedures in mysql?
What is the life of an sql statement?