#坑在于输出的名字顺序要按照employee表存储的顺序来输出,需要在where再加一层子查询 select e.first_name FROM employees e where e.emp_no in (select a.emp_no FROM (SELECT * , row_number() OVER( ORDER by first_name ) as row from employees) as a WHERE a.row%2!=0)
#坑在于输出的名字顺序要按照employee表存储的顺序来输出,需要在where再加一层子查询 select e.first_name FROM employees e where e.emp_no in (select a.emp_no FROM (SELECT * , row_number() OVER( ORDER by first_name ) as row from employees) as a WHERE a.row%2!=0)