SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE

write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh

i want the output

col1 col2 col3
dinesh suresh prakesh

Question Posted / srinivas kondeti

4 Answers
9964 Views
Accenture, TCS, I also Faced
E-Mail Answers

Answer Posted / srinivas kondeti

SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7176

How can informatica be used for an organization?

1273

What is joiner transformation?

1065

Target increases every day even though no new record was inserted

1624

How will the document be delivered to me?

1129

where to store informatica rejected data?

1139

How you know when to use a static cache and dynamic cache in lookup transformation?

1916

How to create Target definition for flat files?

1281

Explain what are the different versions of informatica?

1144

How do you change a non-reusable transformation to reusable transformation?

1046

Explain what are the different types of transformation available in informatica.

1247

What is union transformation?

1015

Did u used latest transformations of 8.6.0? for what?

1924

What is the advantage of informatica?

1123

What is the difference between STOP and ABORT options in Workflow Monitor?

1309