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. >
