Select kode_brg, sum(jumlah) from nama_tabelnya group by kode_brg 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 > >
----------------------------------------------- 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/
