Re: Median with standard SQL
From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Mon, 9 Jul 2001 15:18:21 -0700
Message-ID: <9ida78$vi6$1_at_stlnews.stl.ibm.com>
Date: Mon, 9 Jul 2001 15:18:21 -0700
Message-ID: <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
> 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 Tue Jul 10 2001 - 00:18:21 CEST