我哭了，不加convert函数它就是1.000，2.000,3.000这种排名

select s.emp_no,s.salary,r2.t_rank from salaries s left join
(select @i:=CONVERT(@i+1,SIGNED) as t_rank,r1.salary
from(select distinct salary from
salaries order by salary desc)r1,(select @i:= 0)t)r2
on r2.salary=s.salary order by s.salary desc ,s.emp_no asc