coba juga yang ini : select a.nomor,a.angka,sum(sum(a.angka)) over (order by a.nomor rows unbounded preceding) value from tbl2 a group by a.nomor,a.angka
moga membantu, -bhx- --- Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > 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! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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/
