网站介绍:文章浏览阅读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) order by d.dname; 解释:_grouping function only supported with group by cube or rollup
- 链接地址:https://blog.csdn.net/zhou920786312/article/details/72617457#comments_23274816
- 链接标题:group by 字句的扩展+rollup字句+cube字句+grouping()函数_grouping function only supported with group by cub-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:9361
- 网站标签:grouping function only supported with group by cube or rollup