题解 | #统计salary的累计和running_total#
对于employees表中，给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
我还以为测试用例错了， 当我看到 结果不要排序！！！
我悟了
select e.first_name from employees e join ( select first_name, rank() over (order by first_name) as tmp from employees order by tmp desc )t1 on e.first_name = t1.first_name where t1.tmp % 2 =1
美的集团开奖6人在聊
投递经纬创投等公司7个岗位 >