这个sql语句好难写，sql高手请进。

[ming1]

本人在开发体育成绩处理系统中遇到这样一个问题；
要求在参赛运动员所有成绩中取前8名，这就意味
sql语句必须满足3个条件：
1)成绩有效：success=true
select * from table where success:=true
2)每个运动员最多只有一个最好成绩被选定,即使有两个成绩排在1、2名
(如铅球每人有3次机会,3个成绩)
3)从众多运动员中取前8名
能否只用一条sql语句搞定。各位高手请指教！

[Again]

select top 8 * from table where success=true order by 成绩

[CKEN]

select playerid,max(成绩) from table where success=true
group by playerid

[zcw]

select top 8 playerid,max(成绩) from table where success=true
group by playerid

[blackjack]

select top 8 playerid,max(成绩)
from table
where success=true
group by playerid
order by max(成绩) desc //一定要倒排序，否则不是前8名

[CKEN]

select playerid,max(成绩) from table where success=true
group by playerid order by max(成绩）

[tnhz]

select top 8 *
from table
where success=true
group by playerid
having max(成绩)=成绩
order by 成绩 desc

[torney]

SELECT TOP 8 Max(table.points) AS pointOfMax, table.name
FROM table
where success=true
GROUP BY table.name
ORDER BY Max(table.points) DESC;

[pc00000]

来晚了！都被回答了。。。。