Re: Median and Geometric Mean in Oracle?

[Quoted] Median is difficult, it's pretty much a procedural thing, so I'll skip that one (for the moment at least)

Is the geometric mean the:

    reciprocal of the average of the reciprocals or

    the Nth root of the product of N values ?

I think the former would be:

    select 1/(sum(1/col)) from tab;

and the latter could be

    select exp( sum( ln(col) ) / count(col) ) from tab

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

david_petit_at_yahoo.com wrote in message <80d4pj$q83$1_at_nnrp1.deja.com>...


>

>I want to calculate the median and G. mean of a group of values. Did


>Oracle provide these two functions?

>

>If not, could anyone tell me how to get the median and G. mean of a

>group of numbers?