select s.emp_no,s.salary,r2.t_rank from salaries s left join
(select @i:=@i+1 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
###兄弟们，为什么我这个有小数了，百思不得qijie
自己电脑上的MySQL没有这个问题，我裂开了
京公网安备 11010502036488号