kalo tablenya sederhana itu, bisa dalam satu inline query : CREATE TABLE TBL2 ( NOMOR numeric, ANGKA numeric )
insert into tbl2 values(1,10); insert into tbl2 values(2,15); insert into tbl2 values(3,20); select a.nomor,a.angka,nvl((select b.angka from tbl2 b where b.nomor<a.nomor and rownum<=1),0) + a.angka as value from tbl2 a order by a.nomor asc moga membantu salam, J http://blog.faaza.info mayanti wrote: >Dear All > >Bantuin aku dong, > >misal contoh table > >no nilai >1 10 >2 15 >3 20 > >bagaimana cara membuat query sehingga menghasilkan keluaran spt di bawah ini > >no nilai >1 10 >2 25 >3 45 > >atas bantuannya saya ucapkan terima kasih > >maya > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
