求一个汇总的SQL语句。。。。

[一年]

有表如个
name weight
A1 20
A2 30
A3 40
B1 20
B2 50


求汇总结果如下：
NAME WEIGHT
A 90
B 70

请问这个语句怎么写啊？

[txlicenhe]

Select left(name,1) as name,sum(weight) as weight from 表
group by left(name,1)

[wzh1215]

select name,sum(weight) from (Select left(name,1) as name,weight as weight from 表) tmp group by name

[xlyu]

select left(name,1) 'name',sum(weight) 'weight'
from 表
group by left(name,1)

[zjcxc]

select [name]=left([name],1),weight=sum(weight) from 表
group by left([name],1)

[Arionma]

wzh1215的语句看起来可以，但不可以运行。
另外最好不要用name这种保留字做列名

[Arionma]

wzh1215的语句可以，是我的疏忽。

[Benimarunikado]

--实现如下：

IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'T1')
DROP TABLE T1
GO

CREATE TABLE T1(name char(10),weight int)
GO

INSERT T1 SELECT 'A1',20
UNION SELECT 'A2',30
UNION SELECT 'A3',40
UNION SELECT 'B1',20
UNION SELECT 'B2',50
GO

SELECT LEFT(name,1)AS NAME,SUM(weight)AS WEIGHT
FROM T1
GROUP BY LEFT(name,1)

NAME WEIGHT
---- -----------
A 90
B 70

（所影响的行数为 2 行）

DROP TABLE T1

[Benimarunikado]

或者用下面的语句：


SELECT DISTINCT CAST([name] AS CHAR(1))[NAME],SUM(weight)[WEIGHT]
FROM T1 GROUP BY CAST([name] AS CHAR(1))

[hglhyy]

这个不行吗？
select left(name,1) as name,sum(weight) as weight from tab_table group by name

[chinanewway]

举双手赞成zjcxc(绉建)的写法

[monkeys]

顶马可

[dlpseeyou]

select case([name] as CHAR(1))[name],sum(weight)[weight] from 表名 group by cast([name] as char(1))

[sunsunup]

馬可的取簡單了:Select left(name,1) as name,sum(weight) as weight from 表
group by left(name,1)