Mysql获取成绩排序后的名次
SELECT
a.nickname
,
a.score,
a.avatar,
a.dianhua,
a.spendtime,
(@rowNum :=@rowNum + 1) AS rank
FROM
ims_booleans_exam_user AS a,
(SELECT(@rowNum := 0)) AS b
WHERE
uniacid = 22
ORDER BY
score DESC,
spendtime ASC
LIMIT 200
2021-09-17Mysql获取成绩排序后的名次
最新推荐文章于 2024-07-08 19:28:21 发布