¶ÔACCESSÖг£¹æÈÕÆÚ×ֶεIJéѯ

±íÖÐÓÐÈçÏÂÊý¾Ý£ºÆäÖÐBuyDateTime£¨ÈÕÆÚ/ʱ¼ä£º³£¹æÈÕÆÚ£©£»BuySingle(Îı¾)£» Multiple£¨Êý×Ö£ºÕûÐÍ£©
BuyDateTime    BuySingle Multiple
2010-1-12 0:54:28 023 1
2010-1-12 8:54:28 237 1
2010-1-13 0:54:28 238 1
2010-1-13 8:54:28 239 1
2010-1-13 16:57:38 237 1

1.ÏëʵÏÖ²éÕÒijÈÕÆÚ¶ÎÄÚ£¨È磺2010-1-12µ½2010-1-13£©Ö®¼äµÄ¼Ç¼£»
2.ÓÃBuySingle·Ö×飬ͬ×éÇóMultipleºÏ¼Æ£»
3.²¢°´SumMultipleÓÉ´óµ½Ð¡ÅÅÐò¡£

²éѯ½á¹û£º
    BuySingle SumMultiple
237 2
023 1
238 1
239 1
SQLÓï¾äÔõôд£¿

---

select BuySingle, sum(Multiple) as SumMultiple
where time >= '2010-1-12' and time <= '2010-1-13'
group by BuySingle

---

ʱ¼äÇ°ºóÒª¼Ó#time#,ÕâºÍsql²»Ò»Ñù

---

C# code:
select BuySingle,sum(Multiple ) as 'SumMultiple' from TableName where BuyDateTime >='2010-1-12'
And BuyDateTime <'2010-1-13'
group by BuySingle

---

»¹ÒªÒÔSumMultipleÅÅÐòµÄ

---

×îºó×Ô¼ºÐ´ÁËһϠ       strSql = "SELECT BuySingle,SumMultiple from (SELECT BuySingle,SUM(Multiple) AS SumMultiple from BuyDetail WHERE (BuyDateTime) >= #2010-1-12 00:00:00# AND BuyDateTime <=#2010-1-13 23:59:59#";