dingjun123 发表于 2012-1-2 22:21
就LZ那问题,rollup足矣,a没有null,就直接rollup
再问大侠个东西
with a as (select 'x' a, 'x2' c, 1 b from dual
union all select 'y', 'y2' c, 2 from dual)
select nvl(a.a,'合计'), a.c, sum(a.b) from a group by rollup(a, c);
1
x
x2
1
2
x
1
3
y
y2
2
4
y
2
5
合计
3
怎么把第二行和第四行去掉,我只要最后一行合计的,有专门的处理方法么 |