请教一条分类统计SQL查询语句.

Question

TABLE1：
员工编号(Bh)  姓名(Xm)  产品号(GoodsId) 数量(Sl)  日期(Date)
C001          AAA         ASDF           20       03-02-15
C001          AAA         ASDF           12       03-02-16
C001          AAA         BCDE           30       03-02-17
C002          BBB         ASDF           23       03-02-15
C002          BBB         ASDF           10       03-02-15
..........
-----------------------------------
现想得到这样的结果：
员工编号(Bh)  姓名(Xm)  产品号(GoodsId) 数量(Sl)  日期(Date)
C001          AAA         ASDF           32       03-02-15
C001          AAA         BCDE           30       03-02-17
C002          BBB         ASDF           33       03-02-15
..........
谢谢各位大虾帮助！！

Answer 1

查询日期不需要，即：
员工编号(Bh)  姓名(Xm)  产品号(GoodsId) 数量(Sl)  
C001          AAA         ASDF           32       
C001          AAA         BCDE           30       
C002          BBB         ASDF           33

Answer 2

select bh,xm,goodsid sum(s1) as s1 from table group by bh,xm,boodsid

Answer 3

select 1,2,3,4 from table group by goodsid

Answer 4

select bh,xm,goodsid sum(s1) as s1 ,date1=(select Max(Date) from table b where a.bh=b.bh and a.xm=b.xm and a.goodsid=b.goodsid )from table agroup by bh,xm,boodsid

Answer 5

对了，我后面加个where条件怎么就不可以执行呢

Answer 6

select ...
from ...
where...//位置错了吧
group by

Answer 7

就是这样了：
select bh,xm,goodsid sum(s1) as s1 from tablename group by GoodsId,bh,xm