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

表结构 (姓名,课程,成绩) 现在求获的该表总成绩最高学员的名字

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

select top 1 sum(成绩) as t from table group by 姓名 order by t

select sum(score) as s from table group by name order by s limit 1

select top 1 Name from TableName order by Grade desc;
或者
select Name from TableName order by Grade limit 1;

select top 1 Name from TableName order by Grade desc

select top 1 sum(成绩) as t from table group by 姓名 order by t

select sum(score) score1 from 表名 group by 名字 order by score1 desc limit 1;

谢谢你们 ,你们太好鸟

select top 1 sum(成绩) as t from table group by 姓名 order by t