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

In informatica workflow manager, how many repositories can be created?

1336

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1137

difference between repository database and repository service?

1134

What is meant by a domain?

1111

How to generate or load values in to the target table based on a column value using informatica etl tool.

1053

Explain sessions?

1035

What are the differences between a connected lookup and unconnected lookup?

1057

How to generate sequence numbers?

1071

Explain Dataware house architecture .how data flow from intial to end?

2574

my source is junk data how will u remove that junk data by using unix please any one replay me

3685

Whats there in global repository

1675

What differs when we choose the sorted input for aggregator transformation?

1008

Can you generate sequence numbers without using the sequence generator transformation?

1102

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2124

Make a note of the quantity vaults made in informatica?

971