select first_name
from (select first_name,rank()over(order by first_name)rk
from employees
order by emp_no) t
where rk%2 = 1;
select first_name
from (select first_name,rank()over(order by first_name)rk
from employees
order by emp_no) t
where rk%2 = 1;