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