CREATE TABLE `test1` ( `id` varchar(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `count` varchar(255) DEFA
CREATE TABLE `test1` (
`id` varchar(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`count` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `test2` (
`id` varchar(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- oracle、Mysql通用
select case when t2.id = ‘0‘ then ‘合计‘ else t2.id end id, sum(count) count from test1 t1,test2 t2
where t1.id = t2.name group by t2.id;
-- mysql
select case when id is null then ‘合计‘ else id end id, sum(count) from test1 GROUP BY id with ROLLUP;
-- oracle
select id,sum(count) from test1 group by rollup(id);
sql求合计值(rollup函数应用)
--结束END--
本文标题: sql求合计值(rollup函数应用)
本文链接: https://www.lsjlt.com/news/7385.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0