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.
