opsss... sorry mestinya begini kali : select a.nomor,a.angka,nvl((select sum(b.angka) from tbl2 b where b.nomor<a.nomor),0) + a.angka as value from tbl2 a order by a.nomor asc
salam J http://blog.faaza.info Ujang Jaenudin wrote: >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 --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/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/
