Re: Median with standard SQL

Well, I don't think that works for both even and odd numbers of rows. And I don't think it works if there are multiple rows with identical values. But thanks.

-Jess

"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message news:9ida78$vi6$1_at_stlnews.stl.ibm.com...
> Hint....
> select column from table O where (select count(*) from table where
> column<O.column)=(select count(*)/2 from table)
> Thanks
> Aakash
>
> "Jess Likens" <likens_at_students.uiuc.edu> wrote in message
> news:yqm27.364$oz3.4759_at_vixen.cso.uiuc.edu...
> > 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 Wed Jul 11 2001 - 10:12:35 CEST