mysql分组累计sql问题

nice~！ 引用楼上的实践了一下，可达到预期

SELECT MONTH,SUM(money) money,总累计,省内累计,省外累计 FROM
(SELECT MONTH,money
,(SELECT SUM(money) FROM group_total WHERE MONTH >= '201501' AND MONTH <= r.month) AS '总累计',
(SELECT SUM(money) FROM group_total WHERE MONTH >= '201501' AND MONTH <= r.month AND TYPE='省内') AS '省内累计',
(SELECT SUM(money) FROM group_total WHERE MONTH >= '201501' AND MONTH <= r.month AND TYPE='省外') AS '省外累计'
FROM group_total r
) Y GROUP BY MONTH,总累计,省内累计,省外累计 ORDER BY MONTH;

建表语句

CREATE TABLE `group_total` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'MySQL分组累计SQL',
  `month` varchar(255) DEFAULT NULL,
  `money` int(11) unsigned DEFAULT '0',
  `type` varchar(60) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8

差不多就是下面这样，没有调测，自己试试