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

1 先取出第二大的薪水值

    SELECT max(salaries.salary)
    from employees 
    LEFT JOIN salaries on salaries.emp_no = employees.emp_no
    where salaries.salary < (SELECT max(salary) from salaries)

2 在用第二大的薪水值

SELECT employees.emp_no,salaries.salary,employees.last_name,employees.first_name from  salaries
LEFT JOIN employees on salaries.emp_no = employees.emp_no
where salaries.salary = (
    SELECT max(salaries.salary)
    from employees 
    LEFT JOIN salaries on salaries.emp_no = employees.emp_no
    where salaries.salary < (SELECT max(salary) from salaries)
)