题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
http://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
select emp_no,birth_date,first_name,last_name,gender,hire_date from( select emp_no,birth_date,first_name,last_name,gender,hire_date,rank()over(order by hire_date desc) rk from employees) new where new.rk=1;
