Oracle cube rollup 区别

 rollup()合计函数，求合计

cube （）合计函数 比前一个更详细

例子(也可以叫交叉报表交叉报表)

create table test(sales varchar2(10),dest varchar2(10),revenue number)
insert into test values('smith','hangzhou',1000);
insert into test values('smith','wenzhou',2000);
insert into test values('allen','wenzhou',3000);
insert into test values('allen','wenzhou',4000);

SELECT sales, nvl(dest,'合计'), SUM(revenue) FROM test GROUP BY CUBE(sales, dest);





SELECT sales, nvl(dest,'合计'), SUM(revenue) FROM test GROUP BY ROLLUP(sales, dest);



 



比CUBE少2原因是没有对hangzhou、wenzou 的综合进行统计