高手请帮忙，新手实在不会写

Question

现有一张表 表名tabel1
         KHMC        PZM         GX       SL
          AA          A-01        S1      100
          AA          A-01        S2      120
          AA          A-01        S3      200
          AA          A-01        S1      130
          AA          A-01        S2      56
          AA          A-01        S3      230
          AA          A-01        S1      65
          AA          A-01        S2      69
          AA          A-01        S3      178 
          BB          B-01        S1      100
          BB          B-01        S2      120
          BB          B-01        S3      200
          BB          B-01        S1      130
          BB          B-01        S2      56
          BB          B-01        S3      230
          BB          B-01        S1      65
          BB          B-01        S2      69
          BB          B-01        S3      178                                                 

Answer 1

请帮我写代码整理成  按工序整合 以品种名为组 
    KHMC        PZM        GX      SL 
   AA          A-01        S1      295 
   AA          A-01        S2      245
   AA          A-01        S3      608
   BB          B-01        S1      295 
   BB          B-01        S2      245
   BB          B-01        S3      608
   

Answer 2

select KHMC,PZM,GX,sum(SL)SL
  from table1
 group by KHMC,PZM,GX

Answer 3

select khmc,pzm,gx,sum(sl)
from table1
group by khmc,pzm,gx

Answer 4

select a.khmc,a.pzm,a.gx,nvl(num,0) from 
(select * from (select distinct khmc,pzm from tabel1) a,(select distinct gx from tabel1) b) a,
(select khmc,pzm,gx,sum(sl) num from tabel1 group by khmc,pzm,gx) b
where a.khmc = b.khmc(+) and a.pzm = b.pzm(+) and a.gx = b.gx(+)
order by 1,2,3;

Answer 5

同样的帖子?http://topic.csdn.net/u/20091113/09/086fb41b-ba63-41d7-b5eb-e8113f929ab0.html?seed=556705851&r=61150216#r_61150216

Answer 6

SELECT T.KHMC, T.PZM, T.GX, SUM(T.SL)
  FROM TEST T
 GROUP BY T.PZM, T.GX, T.KHMC
 ORDER BY T.KHMC

Answer 7

  select * from te_v t;
  select t.khmc, t.pzm, t.gx, sum(t.sl)
    from te_v t
   group by t.khmc, t.pzm, t.gx;