有些同学写了很长时间，其实很简单：
select @i:=@i+1 as number,字段，字段 from 表名,(SELECT @i:=0) AS t where 索引 order by 字段 desc
