Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple SELECT scales in a multi-processor env?
You were right, I am sorry... I edited
the version, I see I have to order by date
type in order to range between date interval.
I apologize... :-)
Thanks a lot,
Giovanni
"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message
news:b331ae$1i5qgh$1_at_ID-114658.news.dfncis.de...
> 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:56:25 CST