题解 | #查找最晚入职员工的所有信息#
查找最晚入职员工的所有信息
http://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f
最简单
select emp_no,birth_date,first_name,last_name,gender,hire_date
from employees
order by hire_date
limit 1
max
select emp_no,birth_date,first_name,last_name,gender,hire_date
where hire_date = (select max(hire_date)
from employees
)
用窗口函数
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,
row_number() over(order by hire_date desc) ranking
from employees
) a
where ranking=1