SELECT
*
FROM
(
SELECT
user_id
,
(
@rowNum
:
=
@rowNum
+
1
)
AS
rowNo
FROM
tab_users
,
(
SELECT
(
@rowNum
:
=
0
)
)
b
ORDER
BY
age
DESC
)
c
WHERE
user_id
=
216
;
Mysql 查询用户排行名次
最新推荐文章于 2024-07-29 04:01:00 发布