Date: Fri, 9 Jan 2009 17:20:37 +0100
<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:
| 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
| Anyone smarter??
Have a look at NTILE function.
Michel Received on Fri Jan 09 2009 - 10:20:37 CST