Re: Median function in SQL

From: Dave McRae <dmcrae_at_pcug.org.au>
Date: 1998/03/04
Message-ID: <6dimf6$uba$2@bomb.dynamite.com.au>#1/1

GDay Kevin,
Being at home today, I don't have access to ORACLE to check it out, but I reckon

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
Kevin Merritt wrote in message
<01bd4482$5787d980$c1015c91_at_KMERRITT.GENEVACO.COM>...


>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

Received on Wed Mar 04 1998 - 00:00:00 CST