TOP!! ilustrasi dari jawaban Pak Hamid ada di sini
http://www.indo-oracletech.com/forum/viewtopic.php?f=6&t=206 2008/7/10 Awaluddin Hamid <[EMAIL PROTECTED]>: > Pakek analytic function. > Kira2 begini: > > SELECT tgl, nofaktur, dr, cr, > SUM(saldo) OVER (ORDER BY tgl ROWS UNBOUNDED PRECEDING) saldo FROM ( > SELECT tgl, nofaktur, dr, cr, DECODE(dr,NULL,-cr,dr) saldo > FROM table_transaksi) > > hth, > AH > > > tory byantoro wrote: > > > > Dh, > > saya punya table transaksi > > tgl nofaktur dr cr > > 25/3 F-1234 1500 > > 15/4 F-1235 2500 > > 16/4 Retur1234 500 > > 17/4 F-1236 2500 > > 18/4 Bayar1235 2500 > > 19/4 F-1235 4500 > > Hasil query yang diharapkan > > tgl nofaktur dr cr saldo > > 25/3 F-1234 1500 1500 > > 15/4 F-1235 2500 4000 > > 16/4 Retur1234 500 3500 > > 17/4 F-1236 2500 6000 > > 18/4 Bayar1235 2500 3500 > > 19/4 F-1235 4500 7000 > > Terima kasih sebelumnya. > > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
