对不起
select distinct score
into #temptable
from table
select *
from table
where score > (
select max(score)
from (
select b.score,count(*) "order"
from #temptable a,#temptable b
where a.score>=b.score
group by b.score
having count(*)<3
) a
)
select *
from table
where score > (
select max(score)
from (
select b.score,count(*) "order"
from #temptable a,#temptable b
where a.score<=b.score
group by b.score
having count(*)<3
) a
)