用SQL语句怎样解决这个问题

来源：百度知道 编辑：UC知道 时间：2024/09/22 19:20:21
有一张表，里面装有学生的 姓名 班级 成绩

用SQL语句表示出 平均分最高是哪个班？
表里装有 学生的 学号 班级 成绩

select top 1 班级,avg(成绩) as '平均成绩' from table_name group by 班级
order by 平均成绩 desc

设表名为student
学号 班级 成绩分别为：num，class，score
select class,avs=avg(score)
from student
group by class
order by avs desc
第一行就是成绩最好的班级

1楼 正确的

mysql中:SELECT avg(score) as pj FROM student group by class order by pj desc limit 1
mssql中:SELECT top 1 avg(score) as pj FROM student group by class order by pj desc

select b.class
from (select max(t.grade_avg) max_avg_grade
from (select class, avg(grade) grade_avg
from student
group by class) t) a,
(select class, avg(grade) grade_avg from student group by class) b
where a.max_avg_grade = b.grade_avg