How to list Top 10 salary, without using Rank Transmission?

Question

I have an employee table with 20 records. The columns are employee name and salary. How can I get the details of employees with ranks between 5 and 10 on the basis of decreasing order of their salaries?

I am thinking of passing the table through a sorter to arrange the data in decreasing order of salaries, and then Sequence Generator Transformation giving unique id to the rows and finally a filter to select where the id is between 5 and 10. I realise this isn't an elegant solution? Is there a better way to do this? Thanks for your time

Answer 1

BY USING SORTER TRANSFORMATION USING SORTED PORT AS SAL AND FILTER TRANSFORMATION TO GET FIRST 10 RECORDS

Or-

Use source Qualifier Transformation,we can edit the default

sql query and write like as

select * from ( select * from emp order by sal desc) where rownum <11;

OR-

use sorter--> expression-->filter

1)sorter descend
2)use sequence generator connected expression to generator
sequence,
3)filter the value sequence number greater than 10