题解 | #查找最晚入职员工的所有信息#

最简单

select emp_no,birth_date,first_name,last_name,gender,hire_date
from employees
order by hire_date
limit 1

max

select emp_no,birth_date,first_name,last_name,gender,hire_date
where hire_date = (select max(hire_date)
                    from employees
                    ) 

用窗口函数

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 hire_date desc) ranking
    from employees
    ) a
where ranking=1