yup kang agus,
coba kalo begini,
select tgl, sum(qty) from transaksi where tgl like '%2004' group by tgl
salam
"::Agus Sudana::" <[EMAIL PROTECTED]> on 04/18/2007 03:39:55 AM
Please respond to [email protected]
To: [email protected]
cc: (bcc: Toni Rahayu/IT/domino_srv)
Subject: Re: [Programmer-VB] query SQL transaksi perbulan selama setahun
dear mas tony,
terima kasih bngt..
tapi,klo blh, itu hnya menampilkan per bln jan saja..
agar menampilkan semua qty per bulan (jan, feb,.. dst.) ky apa ya mas..?
regards,
(\__/)
(='.'=) Agus Sudana
(")_(")
----- Original Message ----
From: Toni Rahayu <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, April 18, 2007 10:30:30 AM
Subject: Re: [Programmer-VB] query SQL transaksi perbulan selama setahun
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] com> on 04/18/2007 02:15:28 AM
Please respond to Programmer-VB@ yahoogroups. com
To: milis programmer <Programmer-VB@ yahoogroups. com>
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/paramete r).
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
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
__________________________________________________
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
