sql 查询

显示全部楼层 · 2011-6-17 12:59:31

表s 有name名字和score成绩字段，一个人有多个成绩，查询成绩总和最大的那个人的名字

千问 · 2011-6-17 12:59:31

你什么数据库，SQL server的话楼上正解，oracle就需要把楼上倒数第二行的as去掉select name,max(totalScore ) from(select name,sum(score) as totalScore from S group by name ) newTablegroup by name写成这种。...

千问 · 2011-6-17 12:59:31

select name,max(totalScore ) from(select name,sum(score) as totalScore from S group by name ) as newTablegroup by name...

千问 · 2011-6-17 12:59:31

select top 1 name,sum(score) as totalScore from S group by name order by sum(score) desc...

千问 · 2011-6-17 12:59:31

没玩过...