mysql对查出的数据排序并计算出某条数据排在第几行

最新推荐文章于 2023-02-17 16:08:46 发布

lycIT

最新推荐文章于 2023-02-17 16:08:46 发布

阅读量4.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/lycIT/article/details/81568907

mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文通过一个具体的SQL查询案例，展示了如何从多个表中联接并提取数据，包括左连接操作、条件筛选及排序等关键技术点。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT * FROM(
SELECT *, @curRank := @curRank + 1 AS rank FROM 
(SELECT CT u2.uuid as  as uuid, d, u2.user_ner_name AS user_name, e, u2.fruits_num_num AS fruits_num from (`user` u LEFT JOIN friend f ON ON f.user_uer_uuid =  = u.uuid)
LE)
LEFT JOIN `user` AS u2 ON ON f.friend_use_user_uuid =  = u2.uuid whe where re u.uuid = ' = '223' ORDER BY fruits_num DESC) p
,(SELECT @curRank := 0) q
) s
WHERE uuid = '223'