top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
326 views
How to list Top 10 salary, without using Rank Transmission?
posted Jul 6, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Jul 7, 2015 by Manikandan J
Similar Questions
0 votes

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

...