现有表ABC,数据如下:
DATA NAME SIZE QUANTITY IN OUT SITUATION
2005-10-1 409L/NO.1 (0.50mm)0.44x1234xM 10 20 30 40
2005-10-1 201/2B (0.50mm)0.34x1234xM 30 10 20 10
2005-10-3 409L/NO.1 (3.0mm)0.44x1234xM 20 15 13 20
2005-10-5 201/2B (3.0mm)0.34x1234xM 13 20 32 40
现在要求结果如下:
2005-10-1 409L/NO.1 (0.50mm)0.44x1234xM 10 20 30 40
2005-10-1 201/2B (0.50mm)0.34x1234xM 30 10 20 10
2005-10-3 409L/NO.1 (3.0mm)0.44x1234xM 20 15 13 20
2005-10-5 201/2B (3.0mm)0.34x1234xM 13 20 32 40
(0.44)小计: 30 45 43 60
(0.34)小计: 43 30 52 50
(0.5mm)小计: 40 30 50 50
(3.0mm)小计: 43 35 45 60
(201/2B)小计: 43 30 52 50
(409L/NO.1)小计: 30 35 43 60
月份合计: 73 65 95 110
用SQL语句怎样实现上面结果!!!