1.学生成绩表
create table course_score(
name VARCHAR(255) NOT NULL,
course VARCHAR(255) NOT NULL,
score FLOAT(3) NOT NULL
);
2.SQL
select * from course_score,
(
select c1.course, c1.score
from course_score c1, course_score c2 # 两张表内连接
where c1.course = c2.course and c1.score <= c2.score
group by c1.course, c1.score # 按 课程类型 和 分数 分组
having count(*) <= N # 只保留每一组数量小于等于N的分组
) temp
where course_score.course = temp.course
and course_score.score = temp.score;