求Sql Server合并选择记录方法

[paullow]

在一个表(Table1)中，有如下记录：
SKU# Quantity

05 3
08 1
05 2
04 7
08 2

等等，要求选择后返回结果如下：

SKU# Quantity
04 7
05 5
08 3

即将SKU#相同的记录合并成一条，Quantity字段值求和。
请熟手赐教

[sunlyc20099]

select sum(isnull(Quantity,0))as SKU#,SKU from Table1 group by SKU
绝对正确

[SqlServer2008]

select sum(Quantity),SKU from Table1 group by SKU

[SqlServer2008]

select sum(Quantity) as Quantity,SKU from Table1 group by SKU 

[--小F--]

select sum(Quantity),SKU from Table1 group by SKU 

[oO寒枫Oo]

最好是加个null判断 要是有一个空值 结果就失真了

select sum(isnull(Quantity,0)),SKU from Table1 group by SKU