oracle sql 表的(二)
我在
http://topic.csdn.net/u/20100415/08/aab7d3fc-21eb-4fd8-ba22-819366d2b01c.html?seed=1916314004&r=64680860
提的解了
在
就是有困惑
如果是
name content number
a a1 1
a a2 2
a a3 3
b b1 1
b b2 2
b b3 3
想返回的果是
a a1 1
a a2 2
a a3 3
小 '' 6
b b1 1
b b2 2
b b3 3
小 '' 6
合 '' 12
又要麻大家了


[解决办法]

SQL code

With t As (  select 'a' name,'a1' content, 1 numb From dual Union All  select 'a' name,'a2' content, 2 numb From dual Union All  select 'a' name,'a3' content, 3 numb From dual Union All  select 'b' name,'b1' content, 1 numb From dual Union All  select 'b' name,'b2' content, 2 numb From dual Union All  select 'b' name,'b3' content, 3 numb From dual)SELECT decode(grouping_id(NAME, content), 3, '合计', 1, '小', NAME) NAME, content, SUM(numb) numb  FROM t GROUP BY ROLLUP(NAME, content);
[解决办法]
顶 2楼
[解决办法]
楼主的意思不是很清楚，你想要什么样的结果，你贴出来啊