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

暴力解法先求最大的薪资再求第二的薪资最后求需要的行的数据
SELECT employees.emp_no,salaries.salary,employees.last_name,employees.first_name
from employees LEFT JOIN salaries ON employees.emp_no = salaries.emp_no
where salaries.salary = (SELECT max(salaries.salary) from employees LEFT JOIN salaries ON employees.emp_no = salaries.emp_no where  salaries.salary<(select max(salaries.salary) from employees LEFT JOIN salaries ON employees.emp_no = salaries.emp_no))