34,593
社区成员
发帖
与我相关
我的任务
分享
select pro_manager,DATE_FORMAT(pay_date,'%Y-%m') month ,SUM(sum) total
from m_payment group by pro_manager,month
SELECT a.pro_manager
,a.month
,SUM(b.total) total
FROM ( SELECT pro_manager
,DATE_FORMAT(pay_date , '%Y-%m') month
,SUM(sum) total
FROM m_payment
GROUP BY pro_manager
,month
) AS a
JOIN ( SELECT pro_manager
,DATE_FORMAT(pay_date , '%Y-%m') month
,SUM(sum) total
FROM m_payment
GROUP BY pro_manager
,month
) AS b ON a.pro_manager = b.pro_manager
AND a.MONTH >= b.MONTH
GROUP BY a.pro_manager
,a.MONTH;