Many times we come across scenario ( Mostly in Interview ;-) ) we need to find middle ranks and not top or bottom using rank transformation
lets say My data is like below
B 201
A 100
C 300
D 400
E 500
F 600
G 700
H 800
I 900
I want to find 6th and 5th highest salaries from above ? How to get it .
Answer :
We can use 2 tank transformations and do it
as below
First get bottom 6 in first rank Tns.
Pass them to another Rank and get top 2 from them
And you are done you will get 6th and 5th highest
lets say My data is like below
B 201
A 100
C 300
D 400
E 500
F 600
G 700
H 800
I 900
I want to find 6th and 5th highest salaries from above ? How to get it .
Answer :
We can use 2 tank transformations and do it
as below
First get bottom 6 in first rank Tns.
Pass them to another Rank and get top 2 from them
And you are done you will get 6th and 5th highest