day1. 若同一天入职员工不止一个：distinct去重, select 后加distinct。题目：展示倒数第三天入职员工所有信息答案：select * from employes where hire_date=(select distinct hire_date from employes order by desc hire_date limit 2,1)