SELECt id, name, rank FROM ( SELECt t.id, t.name, @rownum := @rownum + 1 AS rank FROM TABLE t, (SELECT @rownum := 0) r ORDER BY name ASC ) `selection` WHERe id=1
从这个答案>>
ROW_NUMBER（）在MySQL中修改
![获取MYSQL查询中的行位置[重复]](http://www.mshxw.com/aiimages/31/387213.png "获取MYSQL查询中的行位置[重复]")
SELECt id, name, rank FROM ( SELECt t.id, t.name, @rownum := @rownum + 1 AS rank FROM TABLE t, (SELECT @rownum := 0) r ORDER BY name ASC ) `selection` WHERe id=1
从这个答案>>
ROW_NUMBER（）在MySQL中修改
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
