求一条sql语句

[wimming275]

列名: id value

1 1000
1 2000
2 10000
3 8000
3 2000
2 5000
4 600
...

类似这样子，现在想一次过将列名相同的value值求和并显示出来，想得到下面这种效果

id value //

1 3000
2 15000
3 10000
4 600
...

请教这条sql语句该如何写，

[--小F--]

select id,sum(value) as value from tb group by id

[dawugui]

select id , sum(value) value from tb group by id

[好汉坡]

select id,value=sum(value) from tb group by id

[SuqianHome]

   select id,sum(value) as value from tb group by id

[visly]

呵呵 聚簇函数 刚学过

[icelovey]

select id,sum(value) as value from tb group by id

[RYAN--333]

select id,sum(value) as value from tb group by id

[gaomiqzhi]

select id,sum(value) as value from tb group by id

[qiqi860819]

select id,sum([value]) as [value] from table1 group by id