Bisa aja seh kaya gitu, tapi saya mo tanya neh, itu isi field_juml default 500 ga seh, or masih ada nilai yang lain selain 500????
--- Purwedi Kurniawan <[EMAIL PROTECTED]> wrote: > coba diquery pake fungsi aggregate count > > select field_batch, count(field_juml) as jumlah > from namatable > group by field_batch, count(field_juml) > > best regards > [wwn] > > On 1/18/06, pupunk <[EMAIL PROTECTED]> wrote: > > > > Dear pakar2x vb semuanya, > > > > sy mau nanya bgm caranya memfilter data seperti > ini; > > > > *field_batch field_juml* > > AC20125FG 500 > > AC20125FG 500 > > AC20125FG 500 > > AD12051HH 500 > > AD12051HH 500 > > > > yg ingin sy tanyakan bgm caranya menampilkan data > (ex: di dtgrid/ yg lain > > jg boleh) supaya hasilnya sbb: > > > > *field_batch field_juml* > > AC20125FG 3 > > AD12051HH 2 > > > > mohon bantuan pakar-pakar semuanya untuk bisa > membantu sy karena sy masih > > dalam tahap belajar. > > > > thx b-4 > > pupunk > > > __________________________________________________ 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/
