目录 一、题目二、代码三、运行结果 一、题目 二、代码 select em.emp_no, sa.salary, em.last_name ,em.first_name from employees em join salaries sa on em.emp_no = sa.emp_no and sa.salary = ( select max(s2.salary) from salaries s2 where s2.salary< ( select max(s1.salary) from salaries s1 ) ) 三、运行结果