sama aja atuh...
select nama_brg,type,sum(in)-sum(out) as SOH from tablenya group by nama_brg,type
Jangan2x blm dicoba lsg nanya yah... :(
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| [EMAIL PROTECTED]
Sent by: [email protected] 13/07/2006 02:56 PM
|
|
ma kasih bung ronald dan bung mamadh
atas responnya.. querynya bener jitu
ko boleh masih ada satu lage neh
No nama brg in out type
1 abc 2 0 A
2 cde 0 5 A
3 abc 0 1 A
4 abc 6 0 B
5 cde 8 0 A
hasilnya
no nama brg type soh
1 abc A 1
2 abc B 6
3 cde A 3
querynya gimana yachh
best regards
Ali Akbar
Ronald Irawan
<[EMAIL PROTECTED] To: [email protected]
com> cc:
Sent by: Subject: Re: [Programmer-VB] tanya query lage nih ( lanjutan )
[EMAIL PROTECTED]
ogroups.com
07/13/2006 02:27
PM
Please respond to
Programmer-VB
select nama_brg,sum(in)-sum(out) as SOH from tablenya group by nama_brg
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
[EMAIL PROTECTED]
Sent by:
[EMAIL PROTECTED] To
s.com [EMAIL PROTECTED]
roups.com
13/07/2006 02:09 PM cc
Please respond to Subject
[EMAIL PROTECTED] [Programmer-VB]
roups.com tanya query lage nih
( lanjutan )
Assalamuaikum
mas caca dan yg lainya
saya punya tabel
No nama brg in out
1 abc 2 0
2 cde 0 5
3 abc 0 1
4 abc 6 0
5 cde 8 0
menjadi
no nama brg soh
1 abc 7
2 cde 3
gimana querynya yachh
best regards
Ali Akbar
Wahana Programmer Groups Links
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-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/
__._,_.___
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.
