Kalau mau cari tanggal tertentu, maka kita pake syntax HAVING, contoh :
Select Tgl, sum(Harga1), sum(Harga2) >From NamaTabel Group By Tgl HAVING Tgl = '2006-07-26' Kecuali kita tidak mau menampilkan field Tgl, bisa pake WHERE aja,contoh : Select sum(Harga1), sum(Harga2) >From NamaTabel WHERE Tgl = '2006-07-26' Best Regards, Dhani Aristyawan, S.Kom. EDP Supervisor PT. Trias Sentosa Desa Keboharan KM 26 Krian - Sidoarjo _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Darmawan Milist Sent: Wednesday, July 26, 2006 2:36 PM To: [email protected] Subject: Re: [indoprog-vb] Access-SQL: Menjumlahkan Well mas Dhani, Thanks... hihihi, dicari2 ribet amat eee taunya gampang... lha saya udah pake syntax gini gak bisa-bisa : SELECT tgl, sum(h1), sum(h2) FROM tbl WHERE tgl=1 ternyata WHERE diganti GROUP BY thok... thanks ah... wassalam, Darmawan Dhani Aristyawan (EDP) wrote: > > > Dear Bung Darmawan, > > Coba syntax ini : > > Select Tgl, sum(Harga1), sum(Harga2) > > >From NamaTabel > > Group By Tgl > > Semoga membantu > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/SktRrD/hOaOAA/yQLSAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Forum ini berkembang dengan pesat, jika anda memiliki dedikasi dan waktu, silahkan mengaplikasikan diri menjadi moderator. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
