Median function in SQL
From: Kevin Merritt <kevin_merritt_at_genevaco.com>
Date: 1998/02/28
Message-ID: <01bd4482$5787d980$c1015c91_at_KMERRITT.GENEVACO.COM>#1/1
Date: 1998/02/28
Message-ID: <01bd4482$5787d980$c1015c91_at_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 CET