先找到salaries表的salary最大值,
然后查找得出除了最大值的子表,
再获取子表的最大值,也就是第二大的值,
然后连接2个表,再通过where查询得到所有salary第二大的员工信息
SELECT emp_no, salary, last_name, first_name FROM employees JOIN salaries USING(emp_no) WHERE salary = ( SELECT MAX(salary) FROM( SELECT * FROM salaries WHERE salary != ( SELECT MAX(salary) FROM salaries ) ) )