> For the complete documentation index, see [llms.txt](https://r24zeng.gitbook.io/leetcode-notebook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://r24zeng.gitbook.io/leetcode-notebook/bu-chong-4060-dao/178.-rank-scores-sql.md).

# 178. Rank Scores(SQL)

```sql
# Write your MySQL query statement below
select s.Score,
Dense_Rank() over(order by s.Score desc) 'Rank'
from Scores s;

# 或者下面这个，不需要重命名表格Scores
select Score,
Dense_Rank() over(order by Score desc) 'Rank'
from Scores;

# 以下是rank() 的固定语法
# select v,
# Dense_Rank() over(order by v desc) nameOfRankColumn
# from table
```

{% hint style="danger" %}
Rank() 中间可能会跳数字，如1,3,4,6，因为有相同的分数

Dense\_Rank() 中间不跳数字

还是不清楚什么时候需要重命名表格以及如何命名
{% endhint %}