SQL2 查找入职员工时间排名倒数第三的员工所有信息

https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1

解析:这道题目注意同一时间的去重操作

select * from employees
where hire_date = (
    select distinct hire_date from employees
    order by hire_date desc 
    limit 2,1);

知识点:
distinct:去重的