求一条sql语句，单表查询的

Question

表结构 （姓名，课程，成绩） 现在求获的该表总成绩最高学员的名字

Answer 1

mysql 数据库select sum(成绩) as t from table group by 姓名 order by t limit 0,1
oracle数据库 select * from （select sum(成绩) as t from table group by 姓名 order by t） WHERE ROWNUM<=1
sqlserver数据库 select top 1 sum(成绩) as t from table group by 姓名 order by t