答案：

SELECT emp_no,salary,
CASE 
WHEN @salary=s.salary THEN @rank 
WHEN @salary:=s.salary THEN @rank:=@rank+1 
END as t_rank  from salaries s,(SELECT @rank:=0,@salary:=NULL) a 
ORDER BY salary DESC;