Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL to find Rate of Change?

user8860934Sep 4 2011 — edited Sep 4 2011
I have a table, A, it contains date,schmea_name,it's size on daily basis


ex)

01/01/2011 schema_a 100
01/02/2011 schema_a 105
01/03/2011 schema_a 115



Rate of change

01/02/2001 (105 -100) = 5
01/03/2001 (115 -105) = 10

etc

I would like to plot a grpah based on Rate of change, since it is series of data, how i can find rate of change?

Can any one provide me SQL?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2011
Added on Sep 4 2011
3 comments
1,564 views