Mysql 查询用户排行名次

xiaoxiao2021-02-28  4

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 ;
转载请注明原文地址: https://www.6miu.com/read-1600402.html

最新回复(0)