select productcode ,sum(num) as num  from table
group by productcode
order by productcode;

解决方案 »

  1.   

    select productcode,sum(num) as num from productNum group by productcode
    union
    select "总计", sum(num) from productNum;
      

  2.   

    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>
      

  3.   

    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