select name,no,sal,(select max(sal) from emp) as max

source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000

Question Posted / james

Answer Posted / james

select name,no,sal,(select max(sal) from emp) as max_sal
from emp;

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

difference between repository database and repository service?

1084

How many ways are there to do 'remove duplicate records in informatica'?

956

What is enterprise data warehousing?

989

What is the meaning of decode in informatica?

1076

What is update strategy transform?

1021

explain one complex mapping with logic? sales project?

6596

Where are the source flat files kept before running the session?

1013

Plz can any one say me how to get the informatica certification materials and dumps

2001

What is Cognos script editor?

4168

Explain the etl program with few examples.

968

Where is metadata stored?

1045

How does the aggregator transformation handle null values?

1087

What are mapplets? How is it different from a Reusable Transformation?

1034

What are active transformations.

1597

What is intricate mapping?

1096