Dear kang agus,
cobian nganggo ieu,
select sum(qty) from transaksi where tgl like '%01/2004'
ini contoh untuk ngambil total qty bulan january 2004 saja.
Salam
"::Agus Sudana::" <[EMAIL PROTECTED]> on 04/18/2007 02:15:28 AM
Please respond to [email protected]
To: milis programmer <[email protected]>
cc: (bcc: Toni Rahayu/IT/domino_srv)
Subject: [Programmer-VB] query SQL transaksi perbulan selama setahun
dear all,
sy pnya table transaksi dari tahun 2002, berikut cnth field n record2nya
barcode | code | tgl | Size | qty |
074513 C1 03/01/2004 L 2
221520 C2 04/05/2005 M 1
084530 C1 04/02/2005 XL 2
.
.
.dst
saya ingin ambil total qty perbulan dalam setahun (tahun tergantung berapa yg
dimasukkan/parameter).
kira2, sprti apa querynya..?atau, ada di archieve..?
maaf jika sudah pernah ditanyakan.
(\__/)
(='.'=) Agus Sudana
(")_(")
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Toni Rahayu
PT. Omedata Electronics
IT Department
Hunting : (62-22) 6030805 Ext 121
Faxs : (62-22) 6030896
Homepage : http://toni.rahayu.tripod.com
