To Get Maximum 3 values in Datastage
Posted: Sun Dec 12, 2010 10:51 pm
Hi,
I have a table like this
E.No Salary
1 1000
2 2000
3 5000
4 4000
5 1200
I want top three employee numbers who have maximum salary. How can this be acheived?
Thanks,
Anitha
I have a table like this
E.No Salary
1 1000
2 2000
3 5000
4 4000
5 1200
I want top three employee numbers who have maximum salary. How can this be acheived?
Thanks,
Anitha