实例讲解sql server排名函数DENSE_RANK的用法

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