Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Calculate median with ORACLE??

Calculate median with ORACLE??

From: Sylvain Grenier <grenie02_at_cnmtl2.cn.ca>
Date: 1997/02/19
Message-ID: <5ef09r$qdu@nr1.ottawa.istar.net>#1/1

Hi,

I recently had a request to calculate some statistics on a Oracle table values. I have to calculate minimum, maximum, average and median. The three first are not to complicated but a have no idea how to calculate the median. Is there someone that ever had that problem before? If yes, is there a way?

Thanks in advance.

Sylvain. (grenie02_at_cnmtl2.cn.ca) Received on Wed Feb 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US