Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle and quantile
For example:
http://www.xplore-stat.de/help/quantile.html
I looked into analitic functions but i found no example. Anyway not in stright way.
I would be grateful for example
that solves this problem.
Regards,
Grzegorz
"Robert C" <rchin_at_panix.com> wrote in message news:<bnpev3$2q8$1_at_reader2.panix.com>...
> what's a "quantile" ?
> you mean "quartile" ? if so yes, look into analytic functions
>
>
> "Grzegorz" <gb_at_gazeta.pl> wrote in message
> news:16de1593.0310270124.659d0a0e_at_posting.google.com...
> > Hello.
> >
> > Is there a method to get quantile from query?
> > For example:
> >
> > select quantile( f1, 50), quantile( f2, 90) from t
> > where k1 = 'f..k!!!'
> > ?
> >
> > Thanks in advance,
> > Grzegorz
Received on Mon Nov 03 2003 - 08:24:40 CST