Re: creating a time series table...

> my idea of the ??? is:
> avg(amount) over (partition by Account_ID, Person_ID, Month
> order by Day
> range 3 preceding)
>
> but this doesn't work because amount in this case
> amount is not part of the outer GROUP BY clause... also
> because I don't want to generate more rows than 1 for each
> time serie column and I don't have a way to limit the ROWNUM of
> how many rows the analytic function should process, in this case should
>
> be 5 to make sure it doesn't split in max 31/5 = 6 rows per month.
>

Sorry in this case should be 3 to make sure it doesn't split in max 31/3 = 10 rows per month.

> TIA,
> Best Regards,
> Giovanni
>
>
Received on Tue Jan 14 2003 - 09:24:12 CST