select employees.emp_no,salary,last_name,first_name
from employees join salaries
on employees.emp_no=salaries.emp_no
where salary=(
select max(salary) from(
select salary from salaries
where salary!=(select max(salary)
from salaries)) d)

1.max函数表示一组数据中的最大值

2.max用法select max() from