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 ...