select empno,sal,deptno from tablename where (sal,deptno)in(select max(sal)

how to retrive the max(sal),deptno,empno in datastage?

Question Posted / prasad

13 Answers
24374 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / prasad

select empno,sal,deptno from tablename where (sal,deptno)in(select max(sal),deptno from tablename group by deptno)

in datastage

oracle stage->aggregator stage->lookup->dataset

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the use of materialized view?

1555

What is size of a transaction and an array means in a datastage?

1291

What all the types of jobs you developed?

1171

How complex jobs are implemented in datstage to improve performance?

1025

What is a merge in datastage?

1252

What is the importance of the exception activity in datastage?

1059

What are the different layers in the information server architecture?

1117

client know skid info?

2070

What is oci?

1289

What is aggtorec restructure operator?

1427

Differentiate between hash file and sequential file?

1053

What is the difference between passive stage and active stage?

1510

EXPLAIN SCD

1385

What is datastage engine?

1166

If you want to use the same piece of code in different jobs, how will you achieve it?

1138