17,089
社区成员
发帖
与我相关
我的任务
分享
select distinct
nvl(tt.a1,'合计'),
sum(tt.b1),
sum(tt.c1),
sum(tt.b1*tt.c1)
from table1 tt
group by rollup(nvl(tt.a1,'合计'),tt.b1*tt.c1);
select tt.a1,
tt.b1,
tt.c1,
tt.b1*tt.c1
from table1 tt
union all
select nvl(tt.a1,'合计'),
sum(tt.b1),
sum(tt.c1),
sum(tt.b1*tt.c1)
from table1 tt
group by rollup(nvl(tt.a1,'合计'))
order by 1;