mysql实现分组查询前几/后几/第几/倒数第几

mysql实现分组查询每个班级的前三名

set character_set_server = utf8mb4 ;
DROP TABLE IF EXISTS student;

CREATE TABLE IF NOT EXISTS  student(
   id varchar(20),-- 编号
   class varchar(20),-- 年级
   score int-- 分数
);
delete from student;
insert student values('1','OneClass',82);
insert student values('2','OneClass',95);
insert student values('3','OneClass',82);
insert student values('4','OneClass',40);
insert student values('5','OneClass',20);
insert student values('6','TwoClass',95);
insert student values('7','TwoClass',40);
insert student values('8','TwoClass',3);
insert student values('9','TwoClass',60);
insert student values('10','TwoClass',10);
insert student values('11','ThreeClass',70);
insert student values('12','ThreeClass',60);
insert student values('13','ThreeClass',40);
ins