Re: Compute average SQL statement

> 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

Hendrik,

Try analytical functions:

create table avg_ (
  week number,
  value_a number
);

insert into avg_ values (1, 10);
insert into avg_ values (2, 20);
insert into avg_ values (3,  5);

select avg(value_a) over (order by week range unbounded preceding) from avg_;

hth
Rene  

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch