题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name
from(
select first_name,
row_number() over() as r1,row_number() over(order by first_name) as r2
from employees) as tab1
where r2%2=1
order by r1
查看7道真题和解析
