题解 | #查找当前薪水详情以及部门编号dept_no#

select e.emp_no, max(s.salary), e.last_name, e.first_name from employees as e
inner join salaries as s
where 
e.emp_no = (select emp_no from salaries where salary = 
            (select max(salary) from salaries where salary < 
             (SELECT max(salary) from salaries)
            )
           )
and salary < (select max(salary) from salaries)