题解 | #对于employees表中，给出奇数行的first_name#
对于employees表中，给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
SELECT first_name FROM employees WHERE emp_no IN (SELECT emp_no FROM( SELECT emp_no,ROW_NUMBER() OVER( ORDER BY first_name ASC) AS r_num FROM employees) WHERE r_num %2=1)
查看3道真题和解析