对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博客 ” ,链接:http://blog.itpub.net/101162/viewspace-1007754/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/101162/viewspace-1007754/