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

WITH t1 AS (
    SELECT *,
           DENSE_RANK() OVER(ORDER BY hire_date DESC) AS ranking
    FROM employees
),
t2 AS (
    SELECT 
        emp_no,
        birth_date,
        first_name,
        last_name,
        gender,
        hire_date
    FROM t1
    WHERE ranking = 3
    ORDER BY emp_no ASC
)
SELECT * FROM t2;