Re: simple SELECT scales in a multi-processor env?

Hello Jonathan,

> > select sum(to_number(amount)) over
> > (
> > partition by transaction_date
> > order by rowid
> > range between interval '10' day preceding
> > and interval '10' day following
> > ) as highly_smoothed_amount
> > from transaction
> >
> There are a couple of errors in the query, but
> I assume this is just an indication of the sort
> of thing you are trying to do.
>

Thanks a lot for your helpful response, but I wonder what the errors are... because it runs exactly like that ;-)

Best Regards,
Giovanni Received on Thu Feb 20 2003 - 10:53:16 CST