SQL查询排序,并且连续排号

SELECT dense_rank() over (ORDER BY score desc)new_iid, * FROM bumen ORDER BY new_iid

posted @ 2022-01-18 14:48  初雨了然  阅读(135)  评论(0)    收藏  举报