mungkin bisa digunakan fungsi compute
select sku , bahan, qty from table
group by sku , bahan , qty
compute sum ( qty)
selebihnya silahkan dech , pelajari lagi..
hehehe..keep fighting bro..!!!
millist sql indonesia --> [EMAIL PROTECTED]
--- In [email protected], "jonny" <[EMAIL PROTECTED]>
wrote:
>
> hi hasan,
> mungkin dengan 2 query bisa dicoba
> 1.
> select sku,bahan,sum(qty) as qty from table
> group by sku,bahan
> 2. select bahan, sum(qty) as qty from table
> group by bahan
>
> smoga membantu
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] Behalf Of Hasan
> Sent: Tuesday, September 05, 2006 12:06 PM
> To: [email protected]
> Subject: [Programmer-VB] OOT:bantu query
>
>
> Teman2 maaf y kalo oot, gini saya mo tny dong,
> misalnya saya ada data gini...
> sku bahan qty
> 0000001 powder 25
> 0000002 liquid 30
> 0000003 chiller 20
> 0000004 liquid 25
> 0000005 powder 10
>
> Bisa ga seh kalo hasilnya mau ky gini :
>
> sku bahan qty
> 0000001 powder 25
> 0000005 powder 10
> total 35
> 0000002 liquid 30
> 0000004 liquid 25
> total 55
> 0000003 chiller 20
> total 20
>
> Jadi saya mo buat total qty setelah dikelompokkan
> berdasarkan bahannya, kira2 gitu...
> Tolong bantu saya y, kalau ada caranya atau mgkn ada
> yg pny ide lain buat kasus gini,sebelumnya untuk kasus
> gini saya cuma kelompokkan dgn query, trs saya pindah
> ke excel, baru dijumlah disitu.
> O iy, saya sekalian tny jg, ada yg tau ga milis sql
> server Indonesia.
>
> Thanx...
> Hasan
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> 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/
