~~~~~~~Forum Diskusi Software dan Internet untuk Kristen-Katolik~~~~~~~
Sorry salah kirim.. :)
select bulan, sum(terjual) from (
select month(tgl_jual) as bulan, sum(jumlah) as terjual from table_jual
group by tgl_jual) as a
group by bulan
HW> tapi coba ini deh (sukses di SQL Server)
HW> ---
HW> select month(tgl_jual) as bulan, sum(jumlah) as terjual from table_jual
HW> group by tgl_jual
--
Best regards,
Hanny mailto:[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
------ Hemat Bandwith : Hapus pesan yang tidak perlu sebelum reply ------
SUBSCRIBE---> To: [EMAIL PROTECTED], Isi/Body: kosong
UNSUBSCRIBE---> To: [EMAIL PROTECTED], Isi/Body: kosong
Moderator: Ronny <[EMAIL PROTECTED]>, Alex <[EMAIL PROTECTED]>
Web : http://hub.xc.org/cgi-bin/lyris.pl?enter=i-kan-software
