MySQL每个人各科成绩排名_MySQL查询语句：一个成绩排名榜，取出每个人的最好成绩排序，可能需要限定条数...

CREATETABLE`testcx`(`id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'编号,`uid`int(4)NOTNULLCOMMENT'账户id',`reg`varchar(44)collateutf8_unicode_ciNOTNULLCOMMENT'用户成绩,`abcc`var...

CREATE TABLE `testcx` (

`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号,

`uid` int(4) NOT NULL COMMENT '账户id',

`reg` varchar(44) collate utf8_unicode_ci NOT NULL COMMENT '用户成绩,

`abcc` varchar(44) collate utf8_unicode_ci NOT NULL COMMENT '辅助查看用,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------

-- Records of testcx

-- ----------------------------

INSERT INTO testcx VALUES ('1', '1', '15.3746', '1');

INSERT INTO testcx VALUES ('2', '1', '15.3746', '1');

INSERT INTO testcx VALUES ('3', '1', '24.2071', '1');

INSERT INTO testcx VALUES ('4', '6', '16.5027', '2');

INSERT INTO testcx VALUES ('5', '6', '15.6001', '2');

INSERT INTO testcx VALUES ('6', '6', '24.8259', '2');

INSERT INTO testcx VALUES ('22', '1', '25.0513', '7');

INSERT INTO testcx VALUES ('23', '7', '7.75594', '8');

INSERT INTO testcx VALUES ('24', '7', '19.1101', '9');

INSERT INTO testcx VALUES ('87', '12', '66.3684', '20');

INSERT INTO testcx VALUES ('88', '12', '16.4425', '19');

INSERT INTO testcx VALUES ('89', '1', '66.3684', '18');

INSERT INTO testcx VALUES ('15', '1', '22.0435', '3');

INSERT INTO testcx VALUES ('16', '6', '22.2788', '4');

INSERT INTO testcx VALUES ('20', '8', '25.0513', '5');

INSERT INTO testcx VALUES ('21', '9', '25.0513', '6');

INSERT INTO testcx VALUES ('90', '1', '10.3658', '17');

INSERT INTO testcx VALUES ('91', '1', '16.4425', '16');

INSERT INTO testcx VALUES ('92', '1', '39.3519', '15');

INSERT INTO testcx VALUES ('112', '12', '74.9603', '36');

INSERT INTO testcx VALUES ('113', '12', '92.3512', '37');

INSERT INTO testcx VALUES ('114', '12', '90.4196', '38');

INSERT INTO testcx VALUES ('115', '14', '61.8958', '39');

INSERT INTO testcx VALUES ('116', '14', '60.1993', '40');

要求每个人的最好成绩和其他人的最好成绩进行排名，这个查询可能比较频繁。

先谢谢各位高手了。

展开