如何通过sql命令对数据库中的数据重新排序

UPDATE `crm_tag` a SET a.`sort`=(SELECT row_num FROM (SELECT id,`sort`, ROW_NUMBER() OVER (ORDER BY id DESC) AS row_num FROM `crm_tag`) AS b
WHERE a.`id`=b.id);