题解 | 查找employees表emp_no与last_name的员工信息

select 
    emp_no,
	birth_date,
	first_name,
	last_name,
	gender,
    hire_date
FROM (select
      emp_no,
	birth_date,
	first_name,
	last_name,
	gender,
    hire_date ,
    ROW_NUMBER() OVER (ORDER BY emp_no) as row_num
    FROM employees e
) e
where e.row_num % 2 = 1 and e.last_name != 'Mary'
order by e.hire_date desc