"gunartha.nyoman" <[EMAIL PROTECTED]> wrote:
coba pake group :select code,act,user,date,sum(hour) hour from namatabelgroup by code,act,datesemoga membanturegardsnyoman----- Original Message -----From: De ceSent: Thursday, June 15, 2006 8:50 AMSubject: [Programmer-VB] Tanya Select DistinctRekan 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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
