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
13514 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

What is rename command in sql?

1002

What is sql entity?

1076

How to return an array from java to pl/sql?

1111

What is coalesce sql?

976

What are the benefits of pl sql?

1104

What is a call statement? Explain with an example.

990

How do you optimize a stored procedure in sql?

925

what is acid property in database? : Sql dba

1008

Mention what is the function that is used to transfer a pl/sql table log to a database table?

969

how to check server status with 'mysqladmin'? : Sql dba

1052

Which type of cursor is used to execute the dml statement?

940

Is pl sql a scripting language?

1012

How do I count rows in sql?

979

What is ttitle and btitle?

1047

How does sql*loader handles newline characters in a record? : aql loader

1023