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)
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)
牛客博客，记录你的成长
京公网安备 11010502036488号