SQL*PLUS question

From: Hemei <Hemei_at_yahoo.com>
Date: Tue, 16 Mar 1999 22:37:20 -0500
Message-ID: <7cn8kb$onk$2@news.udel.edu>

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 Received on Tue Mar 16 1999 - 21:37:20 CST