题解 | 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;
美的集团公司福利 720人发布
