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

What is an active transformation?

1050

What is informatica etl tool?

959

How to load a Dimension ? and how to load a fact table?

1382

Name the different lookup cache(s)?

1173

While migrating the data from one environment to another environment how would you manage the connections?

1059

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1987

What is xml source qualifier transformation in informatica?

1186

How many ways a relational source definition can be updated and what are they?

975

What is meant by active and passive transformation?

1062

write a query to retrieve the latest records from the table sorted by version(scd)

1029

What is the use of code page?

1030

Informatica settings are available in which file?

949

What is the maplet?

1062

Repository user profiles

1724

What is confirmed fact in dataware housing?

6853