建议以后问问题的时候， 给出表的定义及初始化过程了， 这样大家就容易测试。问题的回复率也高些。
以下是测试脚本
create table f3(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
uid int,
score int,
score_id int
);
insert into f3(uid,score,score_id) values(1,57,213);
insert into f3(uid,score,score_id) values(1,51,215);
insert into f3(uid,score,score_id) values(2,91,219);
insert into f3(uid,score,score_id) values(2,27,254);
insert into f3(uid,score,score_id) values(2,107,321);
insert into f3(uid,score,score_id) values(3,58,323);
insert into f3(uid,score,score_id) values(3,76,327);
insert into f3(uid,score,score_id) values(4,175,329);
