Inginnya jumlah member dengan total hadiah lebih dari 0
ISI table
BULAN MEMBER_ID HADIAH
====================================
200401 1231 10000
200401 1234 12000
200401 1232 5000
200401 1235 0
200402 1231 10000
200402 1234 12000
200402 1232 0
200402 1235 0
Jumlah member dengan total hadiah > 0 = 3
-----Original Message-----
From: panji aryaputra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 1:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [Delphindo] SQL untuk menghitung record dari select-group
select distinct(member_id) from TB_BONUS
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.
