Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 14 Answers
- 21647 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mathan r
create table clustering
(
id1 varchar(10),
id2 varchar(10),
id3 varchar(10)
)
insert into clustering
select '1','2',null
union
select '1',null,'3'
union all
select null,'2','3'
select sum(nullable) from
(select count(case when id1 = null then '1' else '2' end) 'nullable' from clustering where id1 is null
union all
select count(case when id2 = null then '1' else '2' end)'nullable' from clustering where id2 is null
union all
select count(case when id3 = null then '1' else '2' end)'nullable' from clustering where id3 is null ) tmp
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is cascade in sql?
How is data stored on a disk?
Explain locks? : Transact sql
Can you have more than one trigger on a table?
What are joins in sql?
How do I filter in sql profiler?
What is a field in a database?
Can you inner join the same table?
Is it possible for a table to have more than one foreign key?
Does sql require a server?
what is text? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
How do you respond to dementia behavior?
what is the difference between group by and order by in sql? : Sql dba
What does <> sql mean?
