mysql - 获取MySQL查询的位置

Question

MySQL 查询，列出按分数和排名排序的所有记录。但现在，我如何从名称中获取特殊列？

查询:

    SET @a=0; 
    SELECT (@a:=@a+1) as Rank, `player`, `points`, `id` FROM `score` 
    ORDER BY `points` DESC (WHERE player='example');

感谢您的帮助。 :)

我正在使用 Java。

Answer 1

select * from 
(
  SELECT (@a:=@a+1) as Rank, `player`, `points`, `id` 
  FROM `score` 
  CROSS JOIN (select @a := 0) ta
  ORDER BY `points` DESC
) tmp
WHERE player='example'