题解 | #对于employees表中，给出奇数行的first_name#
#坑在于输出的名字顺序要按照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)
查看11道真题和解析