select b.first_name from ( select a.first_name,ROW_NUMBER() over(order by a.first_name) as rank_ from employees a ) b where b.rank_ % 2=1 先找出奇数列， 再通过select X from X where X in () 就可以不带排序了。 select c.first_name from employees c where c.first_name in ( select b.first_name from ( select a.first_name,ROW_NUMBER() over(order by a.first_name) as rank_ from employees a ) b where b.rank_ % 2=1 ) ;