create table abc(
a number,
b number,
c number
)
insert into abc values(1,11,10);
insert into abc values(2,11,20);
insert into abc values(3,22,30);
insert into abc values(4,22,40);
SQL> select a,decode(grouping_id(a,b),2,'小计',3,'总计',b),
2 sum(c)
3 from abc
4 group by rollup(b,(a,b))
5 /