select id,number,dense_rank() over (order by number desc) as t_rank from passing_number 根据运行结果提示,应该选用dense_rank() 窗口函数,且排序按照number降序