Bila memang ingin melakukan sum hanya satu kali, mungkin bisa menggunakan query berikut :
SELECT namabarang, stock AS qty, stock / 100 persen_barang FROM (SELECT a.namabarang, SUM (b.stock) stock FROM inventory a, stock b WHERE a.kodebarang = b.kodebarang GROUP BY a.namabarang) Regards IH --- On Wed, 11/19/08, felino <[EMAIL PROTECTED]> wrote: From: felino <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] PARSING PARAMETER DI ORACLE To: [email protected] Date: Wednesday, November 19, 2008, 2:13 AM maksudnya biar tidak perlu tulis sum dua kali Select a.namabarang, @STOCK:=sum( b.stock) qty,@STOCK /100 persen_barang from inventory a, stock b Where a.kodebarang= b.kodebarang Group by a.namabarang. bisa ngak yach ? salam ----- Original Message ----- From: shinta anistasia To: indo-oracle@ yahoogroups. com Sent: Wednesday, November 19, 2008 1:53 PM Subject: RE: [indo-oracle] PARSING PARAMETER DI ORACLE Ohh ya..bener pak IH, saya lupa nambahin groupingnya. . From: indo-oracle@ yahoogroups. com [mailto:indo-oracle@ yahoogroups. com] On Behalf Of Izzudin Hanafie Sent: Wednesday, November 19, 2008 1:38 PM To: indo-oracle@ yahoogroups. com Subject: RE: [indo-oracle] PARSING PARAMETER DI ORACLE Dear, AFAIK, fungsi SUM, COUNT,MAX,MIN harus diikuti dengan grouping (dalam hal kasus dibawah grouping dilakukan berdasarkan nama barang). Select a.namabarang, sum(b.stock) qty, sum(b.stock) /100 persen_barang from inventory a, stock b Where a.kodebarang= b.kodebarang Group by a.namabarang. Regard's IH --- On Wed, 11/19/08, shinta anistasia <[EMAIL PROTECTED] com <mailto:shinta% 40mgth.com> > wrote: From: shinta anistasia <[EMAIL PROTECTED] com <mailto:shinta% 40mgth.com> > Subject: RE: [indo-oracle] PARSING PARAMETER DI ORACLE To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> Date: Wednesday, November 19, 2008, 1:31 AM Ohh begitu, kalo di oracle, kalo mau menjumlah memang harus menggunakan sum sih. tidak ada cara lain, tapi sebaiknya single query, dengan menggabungkan dua table inventori dan stock supaya data yg ingin ditampilkan terfilter berdasarkan data yg ada di table inventori dan stock tersebut. Contoh: Select a.namabarang, sum(b.stock) qty, sum(b.stock) /100 persen_barang from inventory a, stock b Where a.kodebarang= b.kodebarang Semoga terpecahkan masalah nya mas feline Rgds, Shinta From: indo-oracle@ yahoogroups. com [mailto:indo- oracle@ yahoogroups. com] On Behalf Of felino Sent: Wednesday, November 19, 2008 12:58 PM To: indo-oracle@ yahoogroups. com Subject: Re: [indo-oracle] PARSING PARAMETER DI ORACLE fungsinya sebagai variable , Jadi kalo ada query sbb SELECT NAMABARANG,@ QTY_GDG:= (SELECT SUM(QTY) FROM STOCK) AS QTY,@QTY_GDG/ 100 AS PERSENBRG FROM INVENTORY kalo di oracle SELECT NAMABARANG,( SELECT SUM(QTY) FROM STOCK) AS QTY,(SELECT SUM(QTY) FROM STOCK)/100 AS PERSENBRG FROM INVENTORY jadi si mysql Tidak perlu menulis sum berkali2 salam Felino ----- Original Message ----- From: shinta anistasia To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> Sent: Wednesday, November 19, 2008 12:45 PM Subject: RE: [indo-oracle] PARSING PARAMETER DI ORACLE @ nya sendiri kalo di my sql berfungsi sebagai apa? Alias? Atau fungsi perhitungan , kalo yg dimaksud dengan alias, mending buat query nya seperti dibawah ini = @ yg dimaksud berubah menjadi 'as' select namabarang,harga, jumlah,harga* jumlah as ttl,total/10 as PPN from inventory semoga membantu Rgds Shinta From: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> [mailto:indo- oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> ] On Behalf Of felino Sent: Tuesday, November 18, 2008 3:31 PM To: indo-oracle@ yahoogroups. com <mailto:indo- oracle%40yahoogr oups.com> Subject: [indo-oracle] PARSING PARAMETER DI ORACLE Hello Teman - teman , numpang tanya dong, kalo di mysql perintahnya sbb : select namabarang,harga, jumlah,@total= harga*jumlah as ttl,@total/10 as PPN from inventory pengganti @ di oracle apa yah ? , mohon pencerahannya salam [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
