--- In [email protected], 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-
Coba degh pake ini... Insya' Allah bermanfaat
SELECT Table1.Field1, Table1.Field2, Count(Table1.Field1) AS Jumlah
FROM Table1
GROUP BY Table1.Field1, Table1.Field2;
jabat erat,
Widhie
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/
