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 -> Compute average SQL statement

Compute average SQL statement

From: Hendrik Lampert <henhouse_at_gmx.net>
Date: Wed, 7 Jan 2004 11:32:40 +0100
Message-ID: <btgn8k$809$1@online.de>


Hi,

i'm looking for a sql statement to compute an average from the following sample:

Week Value_a Avg.


1                10                 10 / 1= 10
2                 20                 (10+20) / 2 = 15
3                 5                 (10+20+5 ) / 3 = 11,66
....

The average Avg. should be computed out of Value_a for each week.

Thanks.

Hendrik Received on Wed Jan 07 2004 - 04:32:40 CST

Original text of this message

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