select max(col1) col1,max(col2) col2,max(col3) col3 from table; col1

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 / kart

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

Answer Posted / kart

select max(col1) col1,max(col2) col2,max(col3) col3
from table;

col1 col2 col3
dinesh suresh prkaesh

Is This Answer Correct ?

11 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I edit a trigger in sql developer?

990

What is pl/sql table? Why it is used?

1033

How do I start sql from command line?

1021

Why do we use cursors?

984

explain commit and rollback in mysql : sql dba

1011

What is a table?

1008

What does trigger mean in psychology?

960

does sql support programming? : Sql dba

1037

What is self-join and what is the requirement of self-join?

1149

What is the benefit of foreign key?

1022

what is a record in a database ? : Sql dba

1061

What is an intersect?

1100

What is the purpose of my sql?

945

What is raw datatype in sql?

1042

How do you sort in sql?

1022