Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL to generate percentage growth per time period?
Digeratus 2006 schrieb:
>
> I thimk that you want to know the weekly change between data values.
> You want to compare values of data from two distinct rows. You cannot
> do this easily using SQL. You need to use PL/SQL to do this.
I think, however, this task can be relatively easy done in SQL (and probably more easy than in PLSQL - i mean analytical functions) at least since 8iR2.
Best regards
Maxim Received on Sun Dec 02 2007 - 13:51:00 CST
![]() |
![]() |