On Fri, 3 Dec 2004 13:20:37 +0700, Muhammad Lulud K :)
<[EMAIL PROTECTED]> wrote:
>
>
> Saya mempunyai table dengan field sbb:
>
> BULAN, MEMBER_ID, HADIAH
>
> SQL untuk menghitung jumlah record dari syntax SQL berikut gimana yach..
>
> SELECT MEMBER_ID, SUM(HADIAH) as TOTAL_HADIAH
> FROM TB_BONUS
> GROUP BY MEMBER_ID
> HAVING SUM(HADIAH) > 0
>
>
> Matur Nuwun,
>
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
