Re: Median function in SQL
From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: 1998/03/02
Message-ID: <34FA84FD.6936_at_pcm.bosch.de>#1/1
Date: 1998/03/02
Message-ID: <34FA84FD.6936_at_pcm.bosch.de>#1/1
HiHo.
Can the group-function AVG (average) help you ?
Like:
SELECT AVG(revenue) FROM company_financials WHERE revenue > 1000000
Greez,
Angelo.
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
>
> I can write a stored procedure for each table/column I want to perform this
> for, but I would like to somehow extend the built-in environment to have
> the ultimate flexiblity.
>
> Thanks in advance
-- ----------------------------------------------------------------- Angelo Cavallaro / / / \ TECTUM Beratungsgesellschaft ORACLE-SW-Berater / / / \ für Informationsverarbeitung ancavall.NOSPAM / / /-------\ Tel: 0711/99073-10 _at_aol.com /__/__/_________\ Fax: 0711/99073-99 ----------------------------------------------------------------- Visit the Home of the Green Ribbon Campaign: http://www.ponce.oisoft.com/ -----------------------------------------------------------------Received on Mon Mar 02 1998 - 00:00:00 CET