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: Group functions

Re: Group functions

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Thu, 22 Jul 1999 02:01:37 +0100
Message-ID: <37966D70.DE8C7D7A@ieee.org>


Try this:

SELECT AVG(cost), MAX(price) FROM products;

Feel free to leave a note for more details.

Regards

Breno

Mike Heisz wrote:

> Does anyone know how to write (if posssible?) a function to be used in a
> group function in SQL (i.e. something similar to avg)? I found mention of
> this possibility in the Oracle docs but there are no examples of how to do
> it.
>
> Mike


Received on Wed Jul 21 1999 - 20:01:37 CDT

Original text of this message

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