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

SELECT e.first_name
FROM
    employees e
JOIN (
        SELECT first_name, DENSE_RANK() OVER (ORDER BY first_name) rk
        FROM employees
    ) t ON e.first_name = t.first_name
WHERE t.rk % 2 = 1