题解 | 查找最晚入职员工的所有信息
查找最晚入职员工的所有信息
https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
# 子查询
SELECT *
FROM employees
WHERE hire_date = ( SELECT MAX(hire_date) FROM employees);
#窗口函数
SELECT emp_no,birth_date,first_name,last_name,gender,hire_date
FROM (
SELECT *,
RANK () OVER (ORDER BY hire_date DESC) as hire_rank
FROM employees ) as ranked_emp
WHERE hire_rank = 1 ;
查看15道真题和解析
