select emp_no, birth_date, first_name, last_name, gender, hire_date
from (
    select *,
    dense_rank() over (order by hire_date desc) as dr
    from employees
) temp
where dr=3