牛客：查找当前薪水排名第二多的员工编号emp_n,不用order by

SELECT E.emp_no , S.salary , E.last_name , E.first_name
FROM employees E
JOIN salaries S ON E.emp_no = S.emp_no
WHERE S.salary = 
(    #选取第二高薪水：
    SELECT MAX(salary)
    FROM salaries 
    WHERE salary <
    (   #选取最高薪水：
        SELECT MAX(salary)
        FROM salaries 
    )
);