select id,number, dense_rank() over(order by number desc) t_rank
from passing_number
order by t_rank, id
  • 考察窗口函数