SELECT
e.first_name
FROM employees e JOIN
(
SELECT
first_name
, ROW_NUMBER() OVER(ORDER BY first_name ASC) AS r_num
FROM employees
) AS t
ON e.first_name = t.first_name
WHERE t.r_num % 2 = 1;

我的代码和高赞回答差不多 因为结果要求不排序 所以需要用一个不排序的表作为主表 join另一个表