【牛客网SQL】1: 查找最晚入职员工的所有信息

 

 解答如下：

select *
from employees
GROUP BY hire_date
order by hire_date desc
LIMIT 1

 

posted @ 2021-10-13 22:27  Geeksongs  阅读(44)  评论(0)  编辑  收藏  举报

Coded by Geeksongs on Linux

All rights reserved, no one is allowed to pirate or use the document for other purposes.