题解 | #获取当前薪水第二多的员工的emp_no#
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
就这么点东西。
select
e.emp_no ,
f.salary,
e.last_name,
e.first_name
from employees e join salaries f on e.emp_no = f.emp_no
join (
select
a.salary,
count(distinct b.salary) as rk
from salaries a join salaries b on a.salary <= b.salary
group by a.salary
) d on f.salary = d.salary and d.rk = 2
查看21道真题和解析
