网友收藏group by 字句的扩展+rollup字句+cube字句+grouping（）函数_grouping function only supported with group by cub-CSDN博客
文章浏览阅读360次。1rollup字句 rollup字句扩展group by字句，为每一个分组返回一条小计记录，并为全部分组返回总计列如：rollup字句获取每个部门的工资总计 select d.dname,sum(e.sal) from emp e,dept d where e.deptno=d.deptno group by rollup(d.dname) o......
