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

#窗口函数 select a.first_name from employees a join ( select *,row_number() over(order by first_name) as xh #生成序号 from employees)b on a.emp_no=b.emp_no where b.xh%2!=0 #过滤双数 order by a.emp_no #按原始排序