查出来的列表添加序号

最新推荐文章于 2020-12-29 11:40:04 发布

Kincym

最新推荐文章于 2020-12-29 11:40:04 发布

阅读量1.3k

点赞数

分类专栏： Mysql 文章标签： sql排序

本文链接：https://blog.csdn.net/Kincym/article/details/72916296

版权

Mysql 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

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