M
Mark
I have a query that is arranged acorting to a number.
Name Money
Dan $150
Steve $60
Mike $20
Paul $10
for a lot more records of course. but i want to be able to decide the
person who is the lowest one in each percent as in if i wanted
to produce the following output
Percentile Money
90% $150
80% $150
70% $60
60% $60
50% $60
40% $20
30% $20
20% $10
10% $10
is there an easy way to produce this?
Thanks
-Mark
Name Money
Dan $150
Steve $60
Mike $20
Paul $10
for a lot more records of course. but i want to be able to decide the
person who is the lowest one in each percent as in if i wanted
to produce the following output
Percentile Money
90% $150
80% $150
70% $60
60% $60
50% $60
40% $20
30% $20
20% $10
10% $10
is there an easy way to produce this?
Thanks
-Mark