不适用窗口函数的方法我改写为自连接了 select s1.emp_no, s1.salary, count(distinct s2.salary) as 'rank' from salaries s1, salaries s2 where s1.salary <= s2.salary group by s1.emp_no,s1.salary order by s1.salary desc
1

相关推荐

牛客网
牛客企业服务