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
13327 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 subquery works in sql?

994

Why schema is used in sql?

984

How does join work in sql?

957

Is full outer join same as cross join?

913

What are variables in pl sql?

1092

What are pl/sql cursor exceptions?

1036

What are the advantages of pl sql?

1070

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

What is data control language (dcl)?

1043

Define concurrency control. : Transact sql

1102

What are the different types of dbms?

953

What is sql table?

902

What are the features of pl sql?

1012

What is the difference between partitioning and sharding?

947

What are types of exception?

873