对rollup,对数据合计的功能
1 10
1 22
1 31
2 40
select nvl(line,'合计') line ,sum(value) from kk
group by rollup(nvl(line,'合计'))
order by line
RESULT：
1 63
2 40
103
cube学习:
select * from kk
line value ko
1 10 A
1 22 A
1 31 B
2 40 B
--cube
select line,k0,sum(value)
from kk
group by cube(line,k0)
order by line
RESULT:
1 1 A 32
2 1 B 31
3 1 63
4 2 B 40
5 2 40
6 A 32
7 B 71
8 103
1.增加按line 汇总
2.按ko汇总
3.总合计
-------------------------------
加入grouping函数：
当前汇总记录是利用该字段得出，返回1，否则为0
select decode(grouping(line),1,'月度',to_char(line)) line,
decode(grouping(k0),1'部门',to_char(k0)) k0,sum(value)
from kk
group by cube(line,k0)
order by line,k0
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/101162/viewspace-1007754/ ，如需转载，请注明出处，否则将追究法律责任。
