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

with
t1 as(
    select
        emp_no,
        first_name,
        dense_rank()over(order by first_name) as rank_name
    from
        employees
)

select 
    first_name as first
from
    t1
where
    rank_name % 2 = 1
order by
    emp_no