select id,name,max(sal) from table a; select id,max(sal) from table b;

follwing scenario two table using find maximum salary?

table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000

Question Posted / asdf

5 Answers
9685 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / asdf

select id,name,max(sal) from table a;
select id,max(sal) from table b;

if u want to join two tables
select id,sal from table a,table b where a.id=b.id;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create a node as a gateway node and the same node can be assigned to a grid?

1083

Can you use flat files in Mapplets.

2654

Clarify the aggregator change?

1032

What are the performance considerations when working with aggregator transformation?

1155

What is status code in informatica?

1024

Briefly define reusable transformation?

1133

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1033

Can anyone tell me the new features in Informatica 9 Version?

2132

How do you load unique records into one target table and duplicate records into a different target table?

1263

What is aggregate cache in aggregator transformation?

1148

Explain the features of connected and unconnected lookup.

936

Define mapplet?

1016

How to do the error handling of if ur source is flatfiles?

1969

Differences between connected and unconnected lookup?

1223

What are the different versions of informatica?

1276