求一分組求和sql語句

[dongdony]

對每一組內的某一列小計求和的sql語句?

[txlicenhe]

Select 字段1,sum(字段2) as 小计 from 表 group by 字段1

[wzh1215]

select id,sum(qty) from table1 group by id

[dongdony]

多謝兩位!