select*from employees
where emp_no in
(select emp_no from(
select emp_no,dense_rank()over(order by hire_date desc) as rk
from employees) sub
where sub.rk=3)
order by emp_no