题解 | SQL260 给出employees表中排名为奇数行的first_name
WITH t1 AS (
SELECT
first_name,
ROW_NUMBER() OVER(ORDER BY first_name ASC) AS ranking
FROM employees
),
t2 AS (
SELECT
first_name
FROM t1
WHERE ranking % 2 = 1
),
t3 AS (
SELECT
first_name
FROM employees
WHERE first_name
IN (SELECT first_name FROM t2)
)
SELECT * FROM t3;
# 注意是按照原顺序返回！
