coba : Select Kode, max(Rinician) as Rinician, max(User) as User, Tgl, sum(jam) as hour FROM DETAIL group by Kode, Tgl order by User, Tgl
--- In [email protected], De ce <[EMAIL PROTECTED]> wrote: > > Mas-Mas sekalian, > > Saya sudah rubah field JAM menjadi NUMBER dan saya run dengan query: > > Select Kode, Rinician, User, Tgl, Jam, sum(jam) as hour FROM DETAIL group by Kode, Rinician,User, Tgl, Jam order by User, Tgl > > Tapi hasilnya tetap satu-satu ya (hasil saya attach). > > USER TGL KODE RINICIAN JAM > DC 16/01/2006 7005008 OTHER DEVELOPMENT 1 > DC 16/01/2006 7005008 OTHER DEVELOPMENT 3 > DC 16/01/2006 7005008 OTHER DEVELOPMENT 4 > DC 17/01/2006 8005003 MAINTENANCE 1 > DC 17/01/2006 8005003 MAINTENANCE 4 > > Yang di harapkan hasilnya: > > USER TGL KODE RINICIAN JAM > DC 16/01/2006 7005008 OTHER DEVELOPMENT 7 > DC 17/01/2006 8005003 MAINTENANCE 5 > > Mohon bantuannya, terima kasih. ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/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/
