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

select
    first_name first
from
    employees
where
    first_name in(
        select
            first_name
        from
            (
                select
                    first_name,
                    rank() over(
                        order by
                            first_name
                    ) psn
                from
                    employees
            ) rk
        where
            rk.psn % 2 = 1
    )

筛选出奇数的，然后从原表中筛选first_name in()

这样也可以做出来

但是，我确实对表自连接还不太熟练