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
13621 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 to shut down the server with 'mysqladmin'? : Sql dba

1016

What are triggers and its types?

1074

Can we use two order by clause in query?

969

Is pl sql a scripting language?

1035

what is online transaction processing (oltp)? : Sql dba

999

Can we have two clustered index on a table?

1025

What does an inner join do?

1191

how to create a new view in mysql? : Sql dba

942

What are tables and fields?

1042

How do I sort a table in sql?

1051

Why sql query is slow?

1005

How does cross join work in sql?

1022

What is rtm in testing?

1121

What are instead of triggers?

1046

Is drop table faster than truncate?

996