一个关于SQL语句编写的问题，请大家帮忙

[qianhai]

如何用一句SQL语句来实现如下功能：
如果一个表中字段为：name、value，name为字符型、value为整数数据，我如何查询
出表中name相同，value和最大的纪录
如：
name value
刘 10
陈 5
刘 50
李 40
陈 30

也就是如何查询出 刘 60 请指教！！！！！！

[mjhnet]

select top 1 name, sum(value) from aaa
group by name
order by sum(value) desc

[lxf31]

select name sum(value)
from aaa
where name=x(X是你要查询的NAME)

[dddd8888]

up

[aierong]

select name, max(value) as value
from tablename
group by name

[aierong]

select name, max(value) as 最大记录,sum(value) as 总和
from tablename
group by name

[dxy207]

select name,sum(value) value into #table from a group by name
select top 1 dh,value from #table order by value desc