SELECT
@rownum := @rownum + 1 AS serialNum,obj.*
FROM
(
SELECT
z.id AS "id",
z. NAME AS "name",
ifnull(e.score, 0) AS "score",
z.photo AS "photo"
FROM
z_user z
LEFT JOIN exchange.e_score e ON e.user_id = z.id
where
z.Status = 1
ORDER BY
e.score DESC
) AS obj,
(SELECT @rownum := 0) r
转载请注明原文地址: https://www.6miu.com/read-79286.html
