题解 | 查找最晚入职员工的所有信息

SELECT emp_no, birth_date, first_name, last_name, gender, hire_date
FROM (
    SELECT 
        emp_no, 
        birth_date, 
        first_name, 
        last_name, 
        gender, 
        hire_date,
        RANK() OVER(ORDER BY hire_date) AS rk
    FROM employees
) AS t
WHERE t.rk = (
    SELECT MAX(rk) 
    FROM (
        SELECT RANK() OVER(ORDER BY hire_date) AS rk 
        FROM employees
    ) AS temp
);