题解 | 查找employees表emp_no与last_name的员工信息
查找employees表emp_no与last_name的员工信息
https://www.nowcoder.com/practice/a32669eb1d1740e785f105fa22741d5c
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
