# select * # from employees # order by # hire_date DESC # limit 2,1; select a.emp_no,a.birth_date,a.first_name,a.last_name,a.gender,a.hire_date from ( select emp_no,birth_date,first_name,last_name,gender,hire_date, dense_rank() over(order by hire_date DESC) as rk from employees ) as a where a.rk =3;