select first_name from ( select emp_no ,first_name ,rank() over(order by first_name asc) as rk from employees ) em where em.rk%2=1 order by emp_no asc
select first_name from ( select emp_no ,first_name ,rank() over(order by first_name asc) as rk from employees ) em where em.rk%2=1 order by emp_no asc