题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
select
s.emp_no,
s.salary,
last_name,
first_name
from salaries as s
join employees as e
on s.emp_no = e.emp_no
where s.salary = (
select
max(salary)
from salaries
where salary < (select max(salary) from salaries)
);
