select emp_no,birth_date,first_name,last_name,gender,hire_date
from
(
    select *,
    dense_rank() over(order by hire_date desc) px
    from employees

) b
where px=3