Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: max and avg together
Toomas Kristin wrote:
> Hi!
>
> I have a quite simple problem but I can't resolve this one.
>
> I have a table with structure: date, code and amount. And want to
> compose a query which gives for result date, code and average maximum on
> each day.
>
> For example source data is
> 01-01-2004 A 10.00
> 01-01-2004 A 30.00
> 02-01-2004 B 50.00
> 02-01-2004 C 40.00
> 03-01-2004 A 99.00
>
> and result would be
> 01-01-2004 A 20.00
> 02-01-2004 B 50.00
> 03-01-2004 A 99.00
>
>
> Thx for any help!
If you are on 817+, look up Analytic Function in the docs, tahiti.oracle.com Received on Wed Oct 06 2004 - 17:06:03 CDT