bisa juga gini om. buat report group dw; select kode,
jumlahnya, trus bikin group berdasarkan kode; trus
buat compute column = sum(kode for group 1). beres
dah. so simple kan?
rgds,
--- Erie Santoso <[EMAIL PROTECTED]> wrote:
> coba :
>
> SELECT kode_brg, SUM(jumlah)
> FROM table_name
> GROUP BY kode_brg;
>
> maap kalo salah......
>
>
> On 6/17/07, ziezed <[EMAIL PROTECTED]> wrote:
> >
> > allo semua butuh pencerahan neh, bingung gimana
> caranya menjumlah
> > data per item
> > misal table :
> > kode_brg | jumlah
> > 001 | 3
> > 001 | 5
> > 001 | 1
> > 002 | 2
> > 002 | 5
> >
> > nah pada dw saya ingin buat tampilan seperti ini:
> > kode_brg | jumlah
> > 001 | 9
> > 002 | 7
> >
> > klo ditambah compute field malah semua nya
> dijumlah.
> > gimana sqlnya (apakah ada sintak sqlnya), apakah
> harus dibuatkan
> > tabel temporary
> >
> > makasih,
> > yg lg pusing
> >
> >
> >
>
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
