mysql-单张表查询各科成绩前两名的记录

表结构

CREATE TABLE `t_score` (
  `id` varchar(100) NOT NULL,
  `course` varchar(100) NOT NULL,
  `score` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`,`course`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

表数据

INSERT INTO `t_score` VALUES ('0001', '001', '30');
INSERT INTO `t_score` VALUES ('0001', '002', '88');
INSERT INTO `t_score` VALUES ('0001', '003', '45');
INSERT INTO `t_score` VALUES ('0002', '001', '57');
INSERT INTO `t_score` VALUES ('0002', '003', '33');
INSERT INTO `t_score` VALUES ('0003', '002', '87');
INSERT INTO `t_score` VALUES ('0003', '003', '45');
INSERT INTO `t_score` VALUES ('