#给出排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select t.first_name
from (
select emp_no,first_name,last_name,row_number() over(order by first_name asc) as a
from employees
order by emp_no
) as t
where a % 2 = 1
先用窗口函数编号再搞个子查询
