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
13809 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 version is sql?

1078

What is auto increment?

1048

Mention what does plv msg allows you to do?

1164

What is a column in a table?

1191

What is the difference between left and left outer join?

996

What is the difference between left join and right join?

990

What is a mutating table and a constraining table?

1181

How to Declare Fixed Length String Value In PL SQL

1209

what is blob? : Sql dba

1225

What is over () in sql?

1015

What is the difference between having clause and where clause?

1117

what are all different types of collation sensitivity? : Sql dba

1032

What is the benefit of foreign key?

1075

What is the difference between database trigger and stored procedure?

1144

What is function and procedure in pl sql?

1121