题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select t1.first_name from ( select first_name, row_number() over(order by first_name asc) as num from employees order by emp_no asc) as t1 where mod(t1.num,2)=1
因为原表中emp_no是主键，所以按照原始表中emp_no的顺序升序后输出结果符合原表顺序
查看1道真题和解析