简单来说就是子查询比较是否有大于工资的,如果没有为1,有则+1,记得去重.

SELECT
a.emp_no,
a.salary,
(
select COUNT( DISTINCT b.salary)+1 from salaries b
where
a.salary<b.salary
)as t1
FROM
salaries a
ORDER BY
a.salary DESC