SELECT LOT, SUM(QTY) AS TOTAL FROM NAMATABLE GROUP BY LOT ORDER BY LOT
On 2/16/06, Hasan <[EMAIL PROTECTED]> wrote:
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
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.
