【MySQL】先对入职日期进行分组去除重复日期，再对日期排序找出倒数第三员工的入职日期

SELECT * FROM employees WHERE hire_date = (SELECT hire_date FROM employees GROUP BY hire_date ORDER BY hire_date DESC LIMIT 2,1);