select count(*) from
(SELECT MEMBER_ID, SUM(HADIAH) as TOTAL_HADIAH
FROM TB_BONUS
GROUP BY MEMBER_ID
HAVING SUM(HADIAH) > 0)
hehehehe.
mudah2an ga salah lagi.
hth
panji.a
On Fri, 3 Dec 2004 14:50:52 +0800, panji aryaputra <[EMAIL PROTECTED]> wrote:
> select distinct(member_id) from TB_BONUS
>
>
>
>
> 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.
