题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
SELECT
e.emp_no,
s.salary,
e.last_name,
e.first_name
FROM employees e
JOIN salaries s ON e.emp_no = s.emp_no
WHERE s.to_date = '9999-01-01'
AND s.salary = (
SELECT MAX(salary)
FROM salaries
WHERE to_date = '9999-01-01'
AND salary < (SELECT MAX(salary) FROM salaries WHERE to_date = '9999-01-01')
);
1/用子查询找出最高工资且小于最高工资的人，然后再在上面找最高工资就不会遗漏相同工资的人。
