[comp.databases] Median and Std Deviation in SQL

mikei@ulticorp.UUCP (mikei) (10/31/90)

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.