求一Sql语句。

[totodele]

表：商品
name count 仓库ID
电池 25 1
手电 26 2
电池 25 1
手电 26 2
电池 25 1
手电 26 2
电池 25 1
手电 26 2
电池 25 1
手电 26 2
电池 25 1
手电 26 2

名称只出现一次并求和 让name 跟总数一起显示

[Roy99]

select [name],sum([count]) from tb group by [name]

[shiyuyao1987]

[Quote=引用 1 楼 roy99 的回复:]
select [name],sum([count]) from tb group by [仓库ID]
[/Quote]

[wangcaidpjxwq]

select name,sum(count) from [表名] group by name

[wang13592578713]

select name,count,sum(count) from 表 group by name,Id

[ff1222]

[Quote=引用 1 楼 roy99 的回复:]

select [name],sum([count]) from tb group by [name]
[/Quote]
顶这个，ls的真是千奇百怪什么写法都有。。。name加个[] 必须的

[myhope88]

用group by 就行了吧

[z408638923]

distinct

[nigerenz]

[Quote=引用 3 楼 wangcaidpjxwq 的回复:]
select name,sum(count) from [表名] group by name
[/Quote]

顶

[bucaixiamasha]

select distinct name, sum(count) from [表名] group by name

[bobo_msdn]

select name,sum(count) from [表名] group by name

[smthgdin_020]

select name,sum(count) from [表名] group by name

[a569673493]

select name,count,sum(count) from table group by name? 猜的

[luo7269315]

[Quote=引用 1 楼 roy99 的回复:]
select [name],sum([count]) from tb group by [name]
[/Quote]
+1

[纯唇Yu弄]

[Quote=引用 1 楼 roy99 的回复:]
select [name],sum([count]) from tb group by [name]
[/Quote]

就这个

[liulangdeyuyu]

一楼正解