再求SQL语句一条！

[zftow110]

A表里有字断[名字][分数]，名字可能重复（也就是1个人N个分数）
要求
分数重大到小排序
[名字][总分数]（名字不能重复，分数为所有该名字总合）

[笨笨兔兔兔兔兔]

select 名字,sum(分数) from 表A group by 名字 order by sum(分数)

[singlepine]

select [名字],'总分数'=sum([分数]) from a group by [名字] order by sum([分数]) desc

[nailong]

试试看
select distinct name,sum(score) as total from table group by name order by total desc

[骇客归来]

select [名字],sum([分数]) as '总分数' from a group by [名字] order by '总分数' desc