SELECT `emp_no` ,`birth_date` ,`first_name` ,`last_name` ,`gender` ,`hire_date` FROM ( SELECT *, row_number() over( ORDER BY hire_date DESC ) AS rk FROM employees ) AS employee_ext WHERE rk = 1
SELECT `emp_no` ,`birth_date` ,`first_name` ,`last_name` ,`gender` ,`hire_date` FROM ( SELECT *, row_number() over( ORDER BY hire_date DESC ) AS rk FROM employees ) AS employee_ext WHERE rk = 1