题目:题目描述连接
解答:
方法一:dense_rank() over函数
Select score,dense_rank() over(order by score Desc) As 'Rank'
from Scores;
方法二:分两部分查找再合并
题目:题目描述连接
解答:
方法一:dense_rank() over函数
Select score,dense_rank() over(order by score Desc) As 'Rank'
from Scores;
方法二:分两部分查找再合并