Re: computing median

On Fri, 20 Apr 2001 18:48:13 +0200, Herwig Henseler <hh_at_ecce-terram.de> wrote:

>Hi experts,
>
>[Oracle 8i 8.1.7]
>
>How do I compute the Median of values in a table? I guess this must be a
>FAQ but haven't found an answer so far. The median is the value in the
>"middle" of a sorted list of values. That is, half of all values are
>bigger and the other half is smaller than the median.
>
>TIA,
>Herwig

I heard once a suggestion to use the CUME_DIST function but I believe it needs some logic wrapped around it to give the median.

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/