Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> max and avg together
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! Received on Wed Oct 06 2004 - 16:40:12 CDT