less is more
暂时未有相关通用技术能力~
阿里云技能认证
详细说明2020年05月
2019年08月
2019年07月
同问,最后怎么妥协的呢?
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