Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Group functions
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
![]() |
![]() |