SQL18 查找薪水排名第二多的员工编号emp_no、薪水salary、last_name以及first_name，不能使用order by完成

问题

思路

/*用MAX函数，先查出最大salary，再利用<得到不含最大salary的子表，在子表上再求最大值*/
SELECT e.emp_no, s.salary, e.last_name, e.first_name
FROM employees AS e INNER JOIN salaries AS s
ON e.emp_no = s.emp_no
WHERE to_date = '9999-01-01'
AND salary = (SELECT max(salary)
FROM salaries
WHERE to_date = '9999-01-01'
AND salary < (SELECT MAX(salary)
FROM salaries
WHERE to_date = '9999-01-01')
);