select a.course, a.score, a.name
from student_score a
where (select count(*) from student_score where course = a.course and score > a.score) < 3
order by course, score desc;
查询各科成绩前三名
最新推荐文章于 2023-03-30 16:27:45 发布
select a.course, a.score, a.name
from student_score a
where (select count(*) from student_score where course = a.course and score > a.score) < 3
order by course, score desc;