Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle and quantile

Re: oracle and quantile

From: Grzegorz <gb_at_gazeta.pl>
Date: 3 Nov 2003 06:24:40 -0800
Message-ID: <16de1593.0311030624.62c24e39@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US