computing median

From: Herwig Henseler <hh_at_ecce-terram.de>
Date: Fri, 20 Apr 2001 18:48:13 +0200
Message-ID: <hh-2D0C99.18481320042001@news.f.via-net-works.de>

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

-- 
ECCE TERRAM Internet Services GmbH    Dr. Herwig Henseler
E-Business & Webagentur               Tel. 0441 / 500 12-0
Heinrichstr. 18d                      Fax. 0441 / 500 12-29
26131 Oldenburg                       URL: http://www.ecce-terram.de


"Since I've solved all our Y2K problems, I will be on vacation from

28th Dec 1999 to 6th Jan 1900."

Received on Fri Apr 20 2001 - 11:48:13 CDT