SELECT (@rank :=@rank + 1) AS rank,temp.* FROM (
(SELECT u.* FROM users u ORDER BY u.integral DESC LIMIT 0,5) temp,
(SELECT @rank := 0) b
)
mysql查询结果增加序列号排序
最新推荐文章于 2024-08-18 16:01:03 发布
SELECT (@rank :=@rank + 1) AS rank,temp.* FROM (
(SELECT u.* FROM users u ORDER BY u.integral DESC LIMIT 0,5) temp,
(SELECT @rank := 0) b
)