题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
select emp_no,birth_date,first_name,last_name,gender,hire_date
from
(
select *,row_number() over ( order by hire_date desc ) as rk
from employees
) a
where rk = 1
，大厂实习随便冲，面经多少看点，hot100刷完，大厂随便挑了