select distinct((select col1 from z1 where no is not null))col1,(select col

wirte a query to remove null? following table are

col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output like

col1 col2 col3
dinesh suresh prkaesh

Question Posted / apsar

6 Answers
13375 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / apsar

select distinct((select col1 from z1 where no is not null))col1,(select col2 from z1 where sal is not null)col2,select col3 from z1 where col is not null) from z1
Hint:z1 is Table Name

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are date and time intervals? : Sql dba

1011

What is sql dialect?

1048

What is exception? What are the types of exceptions?

1040

Which version of sql do I have?

1012

What is the main difference between sql and pl/sql?

1045

How is use pl and sql?

1011

Can a foreign key have a different name?

896

Can one improve the performance of sql*loader? : aql loader

988

Which is better varchar or nvarchar?

942

What sql database should I use?

1087

Can we use delete in merge statement?

1012

How to Declare Fixed Length String Value In PL SQL

1114

what are all types of user defined functions? : Sql dba

1007

Explain polymorphism in pl/sql.

1074

Can we rollback delete command?

948