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

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'
 

• « 上一篇：CNN笔记：通俗理解卷积神经网络--理解不同输入通道和卷积核通道关系（红色部分）
• » 下一篇：程序人生二