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
- 22267 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 out parameter used for eventhough return statement can also be used in pl/sql?
What are the possible values that can be stored in a boolean data field?
What is a Mapplet?
What does the hierarchical profiler does?
Explain two easy sql optimizations.
What are sql functions? Describe in brief different types of sql functions?
What is sqlerrm?
How to set up sql*plus output format in oracle?
Can ddl statements be used in pl/sql?
What is the importance of sqlcode and sqlerrm?
How many rows can sqlite handle?
What is character functions?
Difference between table function and pipelined function?
when MSQL8.0 is in market
How to get help at the sql prompt?
