SELECT SUM(IF(hadiah=0,1,0)) as jumlah
from member

hasilnya jumlah=3

mudah2-an begini

Ridwan

----- Original Message -----
From: "Muhammad Lulud K :)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 03, 2004 1:56 PM
Subject: RE: [Delphindo] SQL untuk menghitung record dari select-group


>
> Sintak anda belum menyelesaikan masalah.
>
> 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 Links
>
>
>

>
>
>
>




Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]



Yahoo! Groups Sponsor
ADVERTISEMENT
click here
Web Bug from http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=:HM/A=2455397/rand=475976208


Yahoo! Groups Links

Kirim email ke