高手请进 sql语句问题
table a
商品名称 进货时间 进货数量
a 2002-11-01 00:00:00.0 11
a 2002-11-02 00:00:00.0 34
a 2002-11-03 00:00:00.0 27
a 2002-11-04 00:00:00.0 43
b 2002-11-01 00:00:00.0 1
b 2002-11-02 00:00:00.0 10
b 2002-11-03 00:00:00.0 20
b 2002-11-04 00:00:00.0 40
要得到结果如下
商品名称 进货时间 进货数量 总进货数量
a 2002-11-01 00:00:00.0 11 11
a 2002-11-02 00:00:00.0 34 45
a 2002-11-03 00:00:00.0 27 72
a 2002-11-04 00:00:00.0 43 115
b 2002-11-01 00:00:00.0 1 1
b 2002-11-02 00:00:00.0 10 11
b 2002-11-03 00:00:00.0 20 32
b 2002-11-04 00:00:00.0 40 72