Mysql 获取最新的一条数据

其中 DepartmentId 是要拿到最新数据的关联id
SELECT t1.* FROM User t1 LEFT JOIN User t2 ON t1.DepartmentId = t2.DepartmentId
AND t1.CreateTime < t2.CreateTime WHERE t2.DepartmentId IS NULL

版权声明：本文为ADONETXUEXUZHE原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。