select productcode,sum(num) as num from productNum group by productcode union select "总计", sum(num) from productNum;
SQL> select b1,b3 from b;B1 B3 ---------- --------- emp1 3 emp1 8 emp1 2 emp2 9 emp2 5Executed in 0 secondsSQL> select b1,sum(b3) from b group by b1 2 union 3 select '总计',sum(b3) from b 4 /B1 SUM(B3) ---------- ---------- emp1 13 emp2 14 总计 27Executed in 0.015 secondsSQL>
SQL> select id,num from test1; ID NUM ---------- ---------- 1 3 1 4 2 2 2 5 3 1 3 86 rows selectedSQL> select decode(grouping(id),1,'总计',id) id,sum(num) num 2 from test1 3 group by rollup(id);ID NUM ---------------------------------------- ---------- 1 7 2 7 3 9 总计 23
union
select "总计", sum(num) from productNum;
---------- ---------
emp1 3
emp1 8
emp1 2
emp2 9
emp2 5Executed in 0 secondsSQL> select b1,sum(b3) from b group by b1
2 union
3 select '总计',sum(b3) from b
4 /B1 SUM(B3)
---------- ----------
emp1 13
emp2 14
总计 27Executed in 0.015 secondsSQL>
---------- ----------
1 3
1 4
2 2
2 5
3 1
3 86 rows selectedSQL> select decode(grouping(id),1,'总计',id) id,sum(num) num
2 from test1
3 group by rollup(id);ID NUM
---------------------------------------- ----------
1 7
2 7
3 9
总计 23