Re: Gropus

<mrdjmagnet_at_aol.com> a écrit dans le message de news: 25d75347-6e27-4ef2-af9b-c42dcafae90a_at_35g2000pry.googlegroups.com... On Jan 9, 10:20 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <mrdjmag..._at_aol.com> a écrit dans le message de news: aa21a42e-4ded-42e2-aa71-568394ed6..._at_f40g2000pri.googlegroups.com...
> |
> | I need to do something really weird with some numbers. I need to
> | seperate them into quintiles. Say for example I have these numbers:
> |
> | 5,9,3,6,5,1,34,8,54,98,90,34,55
> |
> | with all these numbers I need to take the top 20% and put them into
> | group 1, the next 20% into group 2, etc......
> |
> | Was looking to find some analytical function....but no luck. So,
> | PLSQL must be the choice. But, I'm having trouble with the
> | logic......
> |
> | Anyone smarter??
> |
> |
>
> Have a look at NTILE function.
>
> Regards
> Michel

This looks similar. I'll have to play with it because I've never heard of this function before.

It does not say anything about ranking and putting into buckets. It also says some things about having to divide evenly into buckets, which will probably not be the case in my situation.......

But I'll see what it does.

It depends on what you meant with "top 20%"... 20% in number of rows or value (with greatest-least=100%) or...?

Regards
Michel Received on Fri Jan 09 2009 - 10:48:25 CST