Re: SQL*PLUS question

C.J. Date's Relational Database Writings 1991-1994 has SQL solutions to getting the median (not average) from a set of values.

In article <7cn8kb$onk$2_at_news.udel.edu>, "Hemei" <Hemei_at_yahoo.com> wrote:

>I have one table, table_a which has two attributes group_id and rate. What I
>want is to retrieve the medium value for each group_id. For example,
> table_a:
> group_id rate
> ------------ ------
> 01 1.0
> 01 1.1
> 01 1.2
> 02 2.1
> 03 3.1
> 03 3.4
> 03 4.0
> 03 4.1
> 03 5.0
>what I want is something like:
> group_id rate
> ------------ ------
> 01 1.1
> 02 2.1
> 03 4.0
>Is there a easy way to do this with sql*plus? Thanks.
>
>Peng Nie

--

Larry Reid                             lcreid@^web.net (remove the ^)