这题的关键在于找出排名为奇数。
排名数也是小于当前first_name的记录数.
排名数为奇数就是它除以2余1.
select first_name
from employees a
where
(select count(*)
from employees b
where a.first_name>=b.first_name)%2 = 1;
from employees a
where
(select count(*)
from employees b
where a.first_name>=b.first_name)%2 = 1;