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: Median function in SQL

Re: Median function in SQL

From: Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de>
Date: 1998/03/03
Message-ID: <34FBD172.BB480B3B@KirchGruppe.de>#1/1

Sorry, I had the wrong notion of median value. I will think about it. Thanks for your clue.

Martin Haltmayer

Steve Jelfs wrote:
>
> Martin Haltmayer wrote:
> >
> > I am not sure, but
> >
> > SELECT (MIN (revenue) + MAX (revenue)) * 0.5 ...
> >
> > might do the trick.
> >
> > Martin Haltmayer
> >
>
> I don't think so, in this group 1,2,10; 2 is the median but your
> algorhithm returns 5.5!
>
> Sj
>
> > Kevin Merritt wrote:
> > >
> > > Does anyone have any idea how to implement a MEDIAN function in Oracle? For
> > > example, I would like to perform the following SQL SELECT statement:
> > >
> > > SELECT MEDIAN(revenue) FROM company_financials WHERE revenue > 1000000
> > >
Received on Tue Mar 03 1998 - 00:00:00 CST

Original text of this message

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