SQL to generate percentage growth per time period?

From: DG problem <skatefree_at_gmail.com>
Date: Tue, 27 Nov 2007 18:30:50 -0800 (PST)
Message-ID: <5408f306-f69e-482e-a126-32f01ecab8f2@e6g2000prf.googlegroups.com>

Just wondering what is the easiest way to show percentage growth of database objects per time period.

For example, what SQL would show the weekly percentage growth of the following data?

alter session set nls_date_format= 'YYYYmmdd'; create table t (time date,mb integer);

insert into t values('20071117',103442);
insert into t values('20071110',97592);
insert into t values('20071103',93446);
insert into t values('20071026',87648);
insert into t values('20071020',84191);
insert into t values('20071013',76495);
insert into t values('20071006',72294);

commit ;
select * from t order by 1 desc ;

Thanks Received on Tue Nov 27 2007 - 20:30:50 CST