coba : select code,acct,user,date,sum(hour) as hour from table group by code,acct,user,date
Deny ----- Original Message ----- From: De ce To: [email protected] ; [email protected] Sent: Thursday, June 15, 2006 6:50 AM Subject: [indoprog-vb] Tanya Select Distinct Rekan mau tanya nih, Code Act User Date Hour 0001 Administrasi Budi 14/06/2006 1 0002 Marketing Budi 14/06/2006 4 0003 Meeting Budi 14/06/2006 1 0001 Administrasi Budi 14/06/2006 1 Data di atas kode 0001 terdapat 2 transaksi dan yang ingin saya tanyakan bagaimana command untuk bisa search sekalian filter dengan tampilan sbb: Code Act User Date Hour 0001 Administrasi Budi 14/06/2006 2 0002 Marketing Budi 14/06/2006 4 0003 Meeting Budi 14/06/2006 1 Kalau saya menggunakan query select distinct code ... maka penjumlahan jamnya tidak ada. Mohon bantuannya. Terima kasih ME __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/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/
