题解 | 给出employees表中排名为奇数行的first_name

-- 首先必须求出排名
WITH ranking_employees AS(
    SELECT *,RANK() OVER(order by first_name) ranking
    FROM employees
)
-- 找出排名为奇数
SELECT first_name
FROM employees
WHERE first_name IN(
    SELECT first_name
    FROM ranking_employees
    WHERE ranking % 2=1
)