题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
连接子查询表即可,最后and和wehere都可以,但是所代表的意义不同,结果一样
select t.first_name from employees as t join (select first_name as r,dense_rank() over(order by first_name) as 序号 from employees )as c on r=t.first_name and mod(序号,2)=1;