思路直接，没什么技巧，应该都可以看得懂吧。代码如下：
select employees.emp_no, salaries.salary, employees.last_name,
employees.first_name from employees, salaries
where employees.emp_no = salaries.emp_no
and salaries.salary =(select max(salaries.salary) from salaries where
salaries.salary < (select max(salaries.salary) from salaries))