Question

用sql查询出课程总分数最高的学生姓名

Name chengji fengshu
张三 数学 75
张三 语文 81
李四 数学 90
李四 语文 76
王五 数学 81
王五 语文 100
王五 英语 90

Answer 1

select name,max(a.fenshu) from
(select name,sum(fenshu) as fenshu group by name) as a
group by name

Answer 2

select top1 name,chengji,max(fengshu) from 表名 group by name;

Answer 3

select top 1 Name
from 成绩表
group by Name
order by sum(fengshu) desc

Answer 4

SELECT NAME
FROM tab
GROUP BY NAME
ORDER BY SUM(fenshu) DESC
WHERE rownum < 2

Answer 5

Select Top1 Name
From TableName
Order by fengshu