mysql在查询结果中增加排序字段

 1 ELECT userId
 2      , (@rowNum := @rowNum + 1) AS runRank
 3      , mostFast1
 4 
 5 FROM
 6   user_info, (SELECT (@rowNum := 0)) b
 7 WHERE
 8   mostFast1 IS NOT NULL
 9 ORDER BY
10   mostFast1

View Code

这种方式只能适用于不家group by的查询，如果加上group by那么排序就会有问题，至于什么原因不清楚

转载于:https://www.cnblogs.com/alexwu59/p/3685900.html