Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*PLUS question

Re: SQL*PLUS question

From: David Bosch Geli <david_at_elpunt.com>
Date: Wed, 17 Mar 1999 09:58:36 -0000
Message-ID: <7cnqm4$2vn$1@diana.bcn.ttd.net>


Try this:

select group_id, avg(rate)
from table a
group by group_id;



David Bosch Geli
Departament d'Informàtica de El Punt
3er ETIG (Enginyeria Tècnica en Informàtica de Gestió) Estudiant de la Universitat De Girona
Adreça: C\ Carme 79, 2on 3era

        17600 Girona (Catalunya)
e-mail: david_at_elpunt.com

        dbosc001_at_correu.udg.es

"Y que importa a nadie
 cómo está mi alma.
 Más triste que el silencio
 y más sola que la luna.
 Y que importa ser poeta
 o ser basura"

       Robe (Extremoduro)


>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 Wed Mar 17 1999 - 03:58:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US