select kode,nama,count(kode) jumlah from tb_nya group by kode. Coba deh..
--- Natanael <[EMAIL PROTECTED]> wrote: > Teman2, > Saya punya tabel, > Kode Nama > A1 AAAAA > A1 AAAAA > A1 AAAAA > B1 BBBBB > C1 CCCCC > C1 CCCCC > > Saya ingin MEnghitung jumlah data itu mengulang > hasil tabelnya kira2 seperti ini > > Kode Nama Jumlah > A1 AAAAA 3 > B1 BBBBB 1 > C1 CCCCC 2 > > ada yang bisa bantu nggak untuk query SQLnya,... > > Best Regards > -NN- > > Send instant messages to your online friends > http://uk.messenger.yahoo.com __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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/
