Re: Median function in SQL
From: Dave McRae <dmcrae_at_pcug.org.au>
Date: 1998/03/04
Message-ID: <6dimf6$uba$2_at_bomb.dynamite.com.au>#1/1
Date: 1998/03/04
Message-ID: <6dimf6$uba$2_at_bomb.dynamite.com.au>#1/1
GDay Kevin,
[Quoted] Being at home today, I don't have access to ORACLE to check it out, but I
reckon
[Quoted] select revenue, max(cntr) from
(select revenue, count(*) as cntr
from company_financials
where ....
group by revenue)
hope this works :)
-- David McRae dmcrae_at_dynamite.com.au Canberra 02 6239 4247 [Quoted] Kevin Merritt wrote in message <01bd4482$5787d980$c1015c91_at_KMERRITT.GENEVACO.COM>...Received on Wed Mar 04 1998 - 00:00:00 CET
>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