#先寻找最高工资
select max(salary)
from salaries
#再寻找第二高工资
# select max(salary)
# from salaries
# where salary != (select max(salary)
# from salaries)

#找到工资第二高员工信息
select salaries.emp_no,salary,last_name,first_name
from employees join salaries on (employees.emp_no = salaries.emp_no)
where salary = (select max(salary)
from salaries
where salary != (select max(salary)
from salaries))