mysql分组之后取每组前几条数据

CREATE TABLE `score` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `score` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;




INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (1, '一班', '小赵', 85);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (2, '一班', '小钱', 70);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (3, '二班', '小孙', 60);
INSERT INTO `score` (`id`, `class`, `name`, `score`) VALUES (4, '三班', '小李', 60);
INSERT INTO `score` (&