UPDATE ccaopreport2020 a,
(SELECT (@r:=@r+1)as seque,qtyUsageAppAll
FROM (SELECT @r:=0) init,ccaopreport2020 ORDER BY qtyUsageAppAll DESC)Y
SET a.seque = y.seque WHERE a.qtyUsageAppAll =y.qtyUsageAppAll
UPDATE ccaopreport2020 a,
(SELECT (@r:=@r+1)as seque,qtyUsageAppAll
FROM (SELECT @r:=0) init,ccaopreport2020 ORDER BY qtyUsageAppAll DESC)Y
SET a.seque = y.seque WHERE a.qtyUsageAppAll =y.qtyUsageAppAll
本文标题:Mysql中根据某一个字段排序后添加排名顺序
本文链接:https://www.haomeiwen.com/subject/jtlszktx.html
网友评论