Silahkan dicoba....SELECT LOT, Sum(QTY) AS QTY FROM Table GROUP BY LOTSalam,BH.Pagi rekans...
Saya mo tanya neh..., saya punya data gini :
LOT LOC QTY
1 A 10
1 B 15
2 C 5
3 STAGE 50
3 D 15
3 E 35
Saya mo cari output yang gini...
LOT QTY
1 25
2 5
3 100
Saya udah coba cari di arsip tapi belum ketemu juga
neh,saya cari di help nya sql 2k juga blm ktm, tolong
dong kalo ada yang bisa bantu saya, gimana ya script
nya??Or kalo memang ada link nya jg ga papa....
Thanx..
Hasan
MM2100
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
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.
