WITH ROLLUP是可选语法,表明是否对分类聚合后的结果进行再汇总
-
表中数据有
-
首先查看没有加 WITH ROLLUP 的结果
select count(*),name from demo group by name;
- 再查看加 WITH ROLLUP 的结果
select count(*),name from demo group by name WITH ROLLUP;
- 结果所知,对对分类聚合后的结果进行再汇总
WITH ROLLUP是可选语法,表明是否对分类聚合后的结果进行再汇总
表中数据有
首先查看没有加 WITH ROLLUP 的结果
select count(*),name from demo group by name;
select count(*),name from demo group by name WITH ROLLUP;