mysql时间间隔年份_计算日期间隔mysql之间的总和

为什么不添加另一个CASE语句：

sum(case when pay_date between '2012-04-01' and '2012-06-01'

then amount end) range_amount

所以你的查询将是：

SELECT p.name,

v.v_name,

SUM(CASE

WHEN MONTH(py.pay_date) = 4 THEN amount

end) april_amount,

SUM(CASE

WHEN MONTH(py.pay_date) = MONTH(CURDATE()) THEN amount

end) current_month_amount,

SUM(CASE

WHEN MONTH(py.pay_date) = MONTH(CURDATE()) - 1 THEN amount

end) previous_month_amount,

SUM(CASE

WHEN pay_date BETWEEN '2012-04-01' AND '2012-06-01' THEN amount

end) range_amount

FROM persons p

LEFT JOIN vehicle v

ON p.id = v.person_veh

LEFT JOIN payment py

ON p.id = py.person_id

GROUP BY p.name,

v.v_name

然后,如果要更改日期范围,可以传递结束日期的值并将其设为变量.