how to select highest 4 salaries from employee table in hr schema in Oracle.
In Talend how can i achieve this ? I could take a tOracleInput(employees table) --> tSortRow(order by salary) --> but then how do i select the top 4 salaries i need to give some auto increment number to each row and then filter the table where auto increment number is less than 5. How to use auto increment ? OR Is there a way where i can access ROWID of Oracle ?