Re: Gropus
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 9 Jan 2009 17:20:37 +0100
Message-ID: <49677956$0$14137$426a74cc_at_news.free.fr>
Date: Fri, 9 Jan 2009 17:20:37 +0100
Message-ID: <49677956$0$14137$426a74cc_at_news.free.fr>
<mrdjmagnet_at_aol.com> a écrit dans le message de news: aa21a42e-4ded-42e2-aa71-568394ed6a22_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
Received on Fri Jan 09 2009 - 10:20:37 CST