题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

SELECT
e.emp_no,
s3.salary,
e.last_name,
e.first_name
FROM employees e
JOIN  salaries s3 on e.emp_no=s3.emp_no
WHERE s3.to_date='9999-01-01' and  s3.salary=(
SELECT
max(salary)
FROM salaries s2
WHERE to_date='9999-01-01'
and s2.salary<(
SELECT 
max(salary)
FROM salaries
    WHERE to_date='9999-01-01'
    )
    )