题解 | 给出employees表中排名为奇数行的first_name
SELECT
first_name
FROM
employees
WHERE first_name IN
(
SELECT a.first_name
FROM (
SELECT
first_name,
rank() OVER(order by first_name) n_rank
FROM employees
) a
WHERE a.n_rank % 2 = 1
)
查看8道真题和解析