题解 | #对于employees表中,给出奇数行的first_name#
对于employees表中,给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name
from (
select first_name,(
select count(*)
from employees
where e.first_name>=first_name
) rank
from employees e
) t
where t.rank&1;
查看11道真题和解析