题解 | #查找入职员工时间排名倒数第三的员工所有信息#

SELECT 
    employees.* 
FROM 
    employees 
INNER JOIN (
        SELECT 
            emp_no,
            ROW_NUMBER() over(ORDER BY hire_date DESC) as num 
            from employees) as a
 ON employees.emp_no = a.emp_no
 WHERE num=3;