Re: Median function in SQL

I am not sure, but

SELECT (MIN (revenue) + MAX (revenue)) * 0.5 ...

might do the trick.

Martin Haltmayer

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
Received on Mon Mar 02 1998 - 00:00:00 CST