How to get the 'N' th max value from the series of records
Posted: Tue Sep 02, 2008 3:39 am
Hi,
Suppose you have 100 records with different salary values from source.
I need to get the Nth max value from 100 records.
Example:
I need to load only the 5th maximum salary value alone into the target table.
How can we achieve this?
Thanks in Advance,
Siva Kumar N![Smile :)](./images/smilies/icon_smile.gif)
Suppose you have 100 records with different salary values from source.
I need to get the Nth max value from 100 records.
Example:
I need to load only the 5th maximum salary value alone into the target table.
How can we achieve this?
Thanks in Advance,
Siva Kumar N
![Smile :)](./images/smilies/icon_smile.gif)