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 / 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
describe transaction-safe table types in mysql : sql dba
Do stored procedures prevent sql injection?
What will you get by the cursor attribute sql%notfound?
what is msql? : Sql dba
What is sql and db2?
Can we use the cursor's to create the collection in PL/SQL?
Why plvtab is considered as the easiest way to access the pl/sql table?
What do you mean by query optimization?
What is a relationship and what are they?
What port does sql server use?
What is the difference between function, procedure and package in pl/sql?
How will you distinguish a global variable with a local variable in pl/sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is composite data type in pl sql?
How do rank () and dense_rank () differ?