Terima kasih atas bantuannya Keren bangetÂ
----- Original Message ---- From: Yoel Susanto <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, July 10, 2008 1:36:35 PM Subject: Re: [indo-oracle] bagaimana buat select untuk cari saldo 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] com>: > 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] [Non-text portions of this message have been removed]
