【错误记录】mysql-Every derived table must have its own alias
select * from (select * from employees order by hire_date desc limit 3) order by hire_date limit 1
错误原因:每个派生出来的表必须有一个自己的别名
错误解决:通过as字段添加别名即可
select * from (select * from employees order by hire_date desc limit 3)as temp order by hire_date limit 1