sql server 根据指定字段排序编号 update 与 order by 联合使用 WITH 表1 AS(SELECT 编号字段名, ROW_NUMBER() OVER(ORDER BY 排序字段名 DESC) AS RowNum FROM 表名)UPDATE 表1SET 编号字段名=RowNum WITH uinfo AS(SELECT orderid, ROW_NUMBER() OVER(ORDER BY grade DESC) AS rowid FROM userinfo)UPDATE uinfo SET orderid=rowid