我有一个交易表,每个客户都有几个交易,每个交易都有点数。
我需要运行一个mysql查询来查找每个客户在一定时间内的积分总和。
每笔交易都有一个客户ID、积分、交易日期
问题是,我只需要为日期范围在两个日期之间的交易找到SUM(Points)GroupBY CustomerID。
像这样:
SELECT SUM(SELECT `Points` FROM `transaction`
WHERE Date BETWEEN '30/09/2012' AND '4/10/2012')
GROUP BY `CustomerID`
请给我上面一个的同等查询。
提前感谢
SELECT SUM(Points) as customerPoints FROM transaction
WHERE Date BETWEEN '30/09/2012' AND '4/10/2012'
GROUP BY CustomerID
SELECT `CustomerID`, SUM(`Points`) AS `Points`
FROM `transaction`
WHERE `Date` BETWEEN '30/09/2012' AND '4/10/2012'
GROUP BY `CustomerID`