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

Home -> Community -> Usenet -> c.d.o.server -> Group by and Median function

Group by and Median function

From: Lisa <lewis_at_mars-systems.com>
Date: Tue, 25 May 1999 08:20:33 -0400
Message-ID: <7ie4jd$2qq$1@usenet01.srv.cis.pitt.edu> 





Hi,


I would like to calculate the median of a group of values in an sql*plus
report.  Oracle doesn't provide MEDIAN as a group by function.  Can anyone
tell me how I would do this?



Thanks


Lisa


P.S. please respond via e-mail!


Received on Tue May 25 1999 - 07:20:33 CDT












Original text of this message













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