declare @t table
(ID int,
 StudentName nvarchar(15),
 Score int)
 
insert into @t
select 1,'黄一',99 union all
select 2,'吴二',99 union all
select 3,'张三',99 union all
select 4,'李四',98 union all
select 5,'王五',97 union all
select 6,'赵六',96 union all
select 7,'田七',95 union all
select 8,'纪八',94 union all
select 9,'邱九',93 union all
select 10,'林十',92　

select t1.* from @t t1
join(select distinct top 5 Score from @t order by Score desc) t2
on t1.Score = t2.Score　　　　

;with cte as(
  select dense_rank() over(order by Score desc) rank,* from @t
)
select * from cte where rank < 6