窗口函数: <窗口函数> over (partition by 分组用列名 order by 排序用列名) 注意:(1)这里的order by 仅用于排名次,不用于按序显示;(2)partition by 可省略 专用窗口函数: rank:1,1,1,.4 dense_rank:1,1,1,2 row_rank:1,2,3,4
解答
select id,number,dense_rank () over (order by number desc) as t_rank
from passing_number
order by number desc,id asc
题目解答知识补充窗口函数:<窗口函数> over (partition by 分组用列名 order by 排序用列名)注意:(1)这里的order by 仅用于排名次,不用于按序显示;(2)partition by 可省略专用窗口函数:rank:1,1,1,.4dense_rank:1,1,1,2row_rank:1,2,3,4解答select id,number,dense_rank () over (order by number desc) as t_rankf