题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

SELECT 
    e.emp_no,
    salary,
    last_name ,
    first_name
FROM employees e
JOIN salaries s ON e.emp_no = s.emp_no
WHERE salary IN 
    (SELECT max(salary)second_salary
    FROM salaries
    WHERE salary NOT IN (SELECT max(salary) max_salary FROM salaries))