mysql按照某个字段分组排序，然后取前面几条数据

建好表和插入数据

DROP TABLE IF EXISTS sec_ques;
CREATE TABLE sec_ques (
city varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
type varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
value smallint(2) NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8；

INSERT INTO sec_ques VALUES (‘重庆’, ‘1’, 100);
INSERT INTO sec_ques VALUES (‘上海’, ‘1’, 100);
INSERT INTO sec_ques VALUES (‘北京’, ‘1’, 98);
INSERT INTO sec_ques VALUES (‘广州’, ‘1’, 96);
INSERT INTO sec_ques VALUES (‘湖南’, ‘1’, 93);

INSERT INTO sec_ques VALUES (‘重庆’, ‘2’, 90);
INSERT INTO sec_ques VALUES (‘上海’, ‘2’, 95);
INSERT INTO sec_ques VALUES (‘北京’, ‘2’, 97);
INSERT INTO sec_ques VALUES (‘广州’, ‘2’, 98);
INSER