题解 | #对于employees表中,给出奇数行的first_name#
对于employees表中,给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
SELECT first_name from employees
where first_name in( select first_name from (SELECT first_name,ROW_NUMBER() over(order by first_name) num
FROM employees ) t where num%2=1)