Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!lll-winken!uunet!ulticorp!mikei
From: mikei@ulticorp.UUCP (mikei)
Newsgroups: comp.databases
Subject: Median and Std Deviation in SQL
Message-ID: <416@ulticorp.UUCP>
Date: 30 Oct 90 16:51:04 GMT
Organization: The Ultimate Corp., East Hanover, NJ
Lines: 14

Greetings SQL Gurus,
 
I am using Gupta's SQLBase and have run into the need to calculate the
MEDIAN and the STANDARD DEVIATION of a group of returned values.  SQLBAse
does not offer functions to do this so I thought someone on the net
might be able to provide a reasonably efficient way of doing this.
 
Thanks for any ideas.
 
...!uunet!ulticorp!mikei
Mike Israel

P.S.  I want to try and do this within the context of an SQL statement but
      can use a cursor if need be.