create table clustering ( id1 varchar(10), id2 varchar(10), id3 varcha

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.

Question Posted / mathan r

14 Answers
22160 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

Please Help Members By Posting Answers For Below Questions

What is the use of double ampersand (&&) in sql queries? Give an example

1133

What is varray in pl sql?

1067

What is natural join in sql?

981

What are the operators in sql?

1022

What is the difference between cluster and non-cluster index?

1104

Can pl sql procedure have a return statement?

1021

What is oracle pl sql developer?

977

What is a database trigger?

1063

What are different types of triggers?

1103

Is there a way to automate sql execution from the command-line, batch job or shell script?

965

Should I use mbr or gpt?

1023

What are the two types of periodical indexes?

936

What is cursor in pl sql?

1110

What is mutating error?

960

What is a procedure in pl sql?

1206