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
9822 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 to elaborate powercenter integration service?

1136

Which transformation is needed while using the Cobol sources as source definitions?

1176

Is it possible to use a client with different version than that of its Informatica server?

1148

What is Cognos script editor?

4238

What is parallel processing in informatica?

1718

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1268

What is a router transformation?

1131

Explain how to import oracle sequence into informatica?

1020

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1129

How you can differentiate between connected lookup and unconnected lookup?

1064

what is Active lock explain

2804

Differentiate between a database and data warehouse?

1147

What is the use of code page?

1096

What is the session task and command task?

1062

What are different types of transformations available in informatica?

993