我使用此查询获取单个总值:
SELECT SUM(`contact_awards`.`amount`) AS amount
FROM (`contact_awards`)
WHERE
`contact_awards`.`gift_award_id` IN (1)
AND `created` BETWEEN '2013-05-05' AND '2014-04-01'
GROUP
BY `contact_awards`.`amount`
但是,当运行时,它生成两行包含
amount
字段:500
1000
为什么它不运行sum
1500
的单行?谢谢你的帮助
最佳答案
删除GROUP BY
子句,
SELECT SUM(contact_awards.amount) AS amount
FROM contact_awards
WHERE contact_awards.gift_award_id IN (1)
AND created BETWEEN '2013-05-05' AND '2014-04-01'
获得两条记录的原因是有两个不同的
contact_awards.amount
值被分组。关于mysql - sql总和和组通过给多个行,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/16280776/