reading data from oracle with duplicates

[chvenkat.v]

hi

i am reading data from oracle table emp: the data look like this...

empno deptno sal
1 10 1000
1 20 2500
1 10 3000
2 10 2500
2 30 500
2 20 2100

i want report like this
maxsal empno deptno no.of emp in dept

pls tell me it can be write in sql query or using any stage in datastage.



thnks
venkat

[ray.wurlod]

This looks like an ideal task for an Aggregator stage. You could also do it in SQL using MAX and COUNT set functions.