SQL> create table run_total (run_date date, run_value number); Table created. SQL> insert into run_total values (sysdate, 0); 1 row created. SQL> insert into run_total values (sysdate, 10); 1 row created. SQL> insert into run_total values (sysdate, 20); 1 row created. SQL> insert into run_total values (sysdate, 30); 1 row created. SQL> insert into run_total values (sysdate, 40); 1 row created. SQL> insert into run_total values (sysdate, 50); 1 row created. SQL> SELECT r1.run_date, r1.run_value, 2 sum(r2.run_value) running_total 3 FROM run_total r1, run_total r2 4 WHERE r2.run_date <= r1.run_date 5 GROUP BY r1.run_date, r1.run_value 6 ORDER BY r1.run_date;
RUN_DATE RUN_VALUE RUNNING_TOTAL --------- ---------- ------------- 17-JUL-06 0 0 17-JUL-06 10 10 17-JUL-06 20 30 17-JUL-06 30 60 17-JUL-06 40 100 17-JUL-06 50 150 6 rows selected. Salam, Indra Armansyah [EMAIL PROTECTED] ----- Original Message ----- From: "Ferry Setiawan" <[EMAIL PROTECTED]> To: "Programmer-Kristen" <[EMAIL PROTECTED]>; "Indo-Oracle" <[email protected]>; "Delphindo" <[email protected]> Sent: Saturday, July 15, 2006 12:22 PM Subject: [indo-oracle] Query Jumlah Bertingkat > Dear All > > mohon bantuannya... > saya menggunakan database Oracle 8i, saya ingin membuat query yang > hasilnya > seperti dibawah ini > > value saldo > 0 0 > 10 10 --> 0 + 10 > 20 30 --> 10 + 20 > 30 60 --> 30 + 30 > 40 100 --> 60 + 40 > 50 150 --> 100 + 50 > > data yang saya punya adalah kolom value, sedang yang ingin dapatkan adalah > data seperti pada kolom saldo > thank's > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > Mirror: http://indooracle.wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.com > Yahoo! Groups Links > > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.10.1/389 - Release Date: 7/14/2006 > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
