Re: oracle and quantile

From: Robert C <rchin_at_panix.com>
Date: Wed, 29 Oct 2003 17:29:20 -0500
Message-ID: <bnpev3$2q8$1@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 Wed Oct 29 2003 - 16:29:20 CST

This message: [ Message body ]
Next message: Tom Miskiewicz: "Comparing Date - Problem"
Previous message: Brian Peasland: "Re: Does Oracle charge for development Licenses"
In reply to: Grzegorz: "oracle and quantile"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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