--- Darmawan Milist <[EMAIL PROTECTED]> wrote:

> Dear all,
> 
> Minta tolong sql querynya kayak apa ya ?
> misal saya punya tabel sbb :
> 
> Tgl   Harga1  Harga2
> 1     100     200
> 1     200     300
> 1     50      100
> 2     50      200
> 2     100     150
> 2     300     200
> dst
> 
> Di query dengan output sbb :
> 
> Tgl   Harga1  Harga2
> 1     350     600       <-- merupakan penjumlahan tgl 1
> 2     45      550       <-- merupakan penjumlahan tgl 2
> dst
> 
> Mohon bantuan dan informasi.
> Thanks.
> Darmawan
> 



Semoga membantu ya :D

select tgl,sum(harga1),sum(harga2)
from ......
group by tgl


klo salahh mohom mnagaaappp ya :D

Lain guru lain ilmu mohon jng menganggu ====> nyambung
kgk sih 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


------------------------ Yahoo! Groups Sponsor --------------------~--> 
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/3EuRwD/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/
 



Kirim email ke