题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
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 ) AS employee_ext WHERE rk = 1