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

Explain the select statement in sql?

1177

define sql insert statement ? : Sql dba

1080

What is trigger in flip flop?

1060

explain what is mysql? : Sql dba

1128

Is left join inner or outer by default?

1069

Is sql database free?

1024

What is dba in sql? : SQL DBA

1091

What is union, minus and interact commands?

1361

who introduced sql?

1069

Can we create a trigger on view?

944

What is asqueryable?

1035

Can a trigger call a stored procedure?

1125

Is join and inner join the same?

1039

Which table is left in left join?

1060

What is multiple partition?

1017