Median function in SQL

From: Kevin Merritt <kevin_merritt_at_genevaco.com>
Date: 1998/02/28
Message-ID: <01bd4482$5787d980$c1015c91@KMERRITT.GENEVACO.COM>#1/1

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 Sat Feb 28 1998 - 00:00:00 CST