跪求一個sql查詢語法

Question

对，用union
select * from tablename
union
select '总和',sum(b),sum(c) from tablename

Answer 1

select a,b,c from table1
union
select '總和',sum(b),sum(c) from table1;

Answer 2

thank you very much !! 
I Will top !!

Answer 3

SQL> select  * from test1;USERID           NUM1       NUM2
---------- ---------- ----------
user001            12         32
user003            23         32
user002            31         13
user004            23         43SQL> select userid,sum(num1),sum(num2) from test1 t
  2  group by rollup(userid);USERID      SUM(NUM1)  SUM(NUM2)
---------- ---------- ----------
user001            12         32
user002            31         13
user003            23         32
user004            23         43
                   89        120

Answer 4

SQL> select decode(grouping(userid),1,'总合',userid) userid,
  2  sum(num1),sum(num2) from test1 t
  3  group by rollup(userid);USERID      SUM(NUM1)  SUM(NUM2)
---------- ---------- ----------
user001            12         32
user002            31         13
user003            23         32
user004            23         43
总合               89        120

Answer 5

就这问题也“跪求....”，mys.

Answer 6

select decode(grouping(userid),1,'总合',userid) userid,
  sum(num1),sum(num2) from test1 t
 group by cube(userid);