SELECT b.* FROM ( SELECT t.*, @rownum := @rownum + 1 AS rownum FROM (SELECT @rownum := 0) r, (SELECT * FROM 表 ORDER BY 成绩 DESC ) AS t ) AS b WHERE b.用户 = 用户; 试试这个
SELECT b.* FROM ( SELECT t.*, @rownum := @rownum + 1 AS rownum FROM (SELECT @rownum := 0) r, (SELECT * FROM 表 ORDER BY 成绩 DESC ) AS t ) AS b WHERE b.用户 = 用户;
81,122
社区成员
341,744
社区内容
加载中
试试用AI创作助手写篇文章吧