1.找出最高salary
select max(salary) max_salary
from salaries

2.排除最高salary
select e.emp_no, max(s.salary) salary, e.last_name, e.first_name
from employees e
join salaries s
on e.emp_no = s.emp_no
where salary < (
select max(salary) max_salary
from salaries)