mysql8 rank_MySQL8.0 ROW_NUMBER、RANK、DENSE_RANK窗口函数 分组排序排名

MySQL8.0 (ROW_NUMBER)窗口函数 排名

暂时理解函数意义，后面再进行优化，如果有关变量排序，查看这个大哥的

先查看一个例子：

# 按照每科课程分数进行排序，cid :课程编号， sid: 学号

select sid,cid,score,

row_number() over(partition by cid order by score desc) as 'rank',

RANK() over(partition by cid order by score desc) as 'rank2',

DENSE_RANK() over(partition by cid order by score desc) as 'rank3'

from sc

row_number() over(partition by sid order by score desc)

使用窗口函数，over在函数调用后包含一个字句，over有两种形式

row_number() {over(window_spec) | over (window_name)}

window_spec:

[window_name] [partition_clause] [order_clause] [frame_clause]

partition_clause:

PARTITION BY expr [, ex