Median with standard SQL

Does anyone have a method to get the median of a relation using only the following SQL commands: SELECT, DISTINCT, WHERE, FROM, LIKE, EXISTS, IN, UNION, INTERSECT, EXCEPT/MINUS, ANY, ALL, COUNT, SUM, AVG, MAX, MIN, GROUP BY, HAVING, ORDER BY, JOIN? I can't seem to come up with anything. The median of n elements occurs at (n+1)/2 for an odd number of elements and it is the average of n/2 and n/2 and (n+1)/2. Any help would be much appreciated.

-Jess Received on Mon Jul 09 2001 - 13:13:07 CDT