select distinct a.user,a.kode,a.rincian,
(select sum(jam) from table1 where table1.kode=a.kode and month(tgl)=6) Jun,
(select sum(jam) from table1 where table1.kode=a.kode and month(tgl)=7) Jul,
(select sum(jam) from table1 where table1.kode=a.kode and month(tgl)=8) Aug
from Table1 A
Mudah2xan bisa ,karena gak bisa nyoba :)
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| De ce <[EMAIL PROTECTED]>
Sent by: [email protected] 20/06/2006 06:42 AM
|
|
Mau tanya mengenai penggabungan & penjumlahan data, contoh tabel Detail:
User Tgl Kode Rincian Jam
Budi 01/06/2006 0100205 Administration 2
Budi 01/06/2006 0200001 Marketing 5
Budi 02/06/2006 0100205 Administration 3
Budi 02/06/2006 0200001 Marketing 4
Budi 05/06/2006 0100205 Administration 2
Budi 05/06.2006 0100006 Meeting 2
Budi 05/06/2006 0200001 Marketing 4
Budi 10/07/2006 0100007 Meeting Divisi 7
Report yang di harapkan adalah sbb:
User Kode Rincian Jun Jul Aug
Budi 0100205 Administration 7 0 0
Budi 0200001 Marketing 13 0 0
Budi 0100006 Meeting 2 0 0
Budi 0100007 Meeting Divisi 0 7 0
Mohon bantuan dari rekan-rekan untuk command/query-nya apakah menggunakan select distinct atau yang lainnya?
Trims.
De
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1ยข/min.
__._,_.___
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.
