题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

SELECT
    emp_no,
    birth_date,
    first_name,
    last_name,
    gender,
    hire_date
FROM
    (
        SELECT
            dense_rank() OVER (
                ORDER BY
                    hire_date DESC
            ) as num,
            emp_no,
            birth_date,
            first_name,
            last_name,
            gender,
            hire_date
        FROM
            employees
    ) AS A
WHERE
    A.num = 3
order by emp_no ASC;