题解 | 给出employees表中排名为奇数行的first_name
select first_name from (select emp_no,first_name, row_number()over(order by first_name ) r from employees) a where a.r%2!=0 order by emp_no asc
,这里要求按原表排序,我认为可以利用员工号决定最后的输出·
select first_name from (select emp_no,first_name, row_number()over(order by first_name ) r from employees) a where a.r%2!=0 order by emp_no asc
,这里要求按原表排序,我认为可以利用员工号决定最后的输出·
相关推荐