题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
with t as (select *,ROW_NUMBER() over(order by first_name)as ranking from employees order by emp_no) select t.first_name from t where power(-1,ranking)<0核心在于排个序
