一关于去重复值、排序、求合等功能的SQL语句，高手帮忙看看

Question

栋号         成品代号                 宽度          高度          数量          面积    
---------- -------------------- ----------- ----------- ----------- -------------------------
6#,3#      YC4522               5240        1965        36          37067.760000000002
6#,3#      YC4522'              5240        1965        10          10296.6
6#,3#      YC1821A              3182        2015        9           5770.5569999999998
6#,3#      YC1821B              3182        2015        9           1000.0
6#,3#      YC2222A              4227        2155        8           1000.0
6#,3#      YC2222B              4227        2155        8           1000.0
6#         YC4522               5240        1965        36          37067.760000000002
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
6#         YC4522               5240        1965        36          37067.760000000002
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
2#         aa001                600         900         20          1080.0
2#         bb002                700         800         20          1120.0
2#         cc003                600         600         20          720.0
3#         abcd                 400         500         30          600.0
3#         efgh                 500         600         40          1200.0
3#         ijklm                600         700         50          2100.0
3#         opqrst               700         800         60          3360.0
3#         abcd                 400         500         60          1200.0
3#         efgh                 500         600         120         3600.0要实求如下功能：
栋号 成品代号  宽度  高度  均相同的记录，则去掉重复值，但其数量、面积在去重复值前应求合。请高手帮帮忙呀

Answer 1

select 栋号 ,   成品代号, 宽度 ,高度, sum(数量) 数量,sum( 面积) 面积 from table group by 栋号 ,   成品代号, 宽度 ,高度

Answer 2

xyxfly(小虾米) ( ) 信誉：100    Blog 的写法是可以的.除非楼主是想达到这个目的:
select 栋号,成品代号,宽度,高度,sum(数量 * 面积) AS 面积 
from [table]
group by 栋号,成品代号,宽度,高度

Answer 3

xyxfly(小虾米)
写的是对的啊？楼主到底想要实现什么样的功能呢？