您应该找出
timestamp每个组（子查询）中的最后一个值，然后将此子查询加入到表中-
SELECt t1.* FROM messages t1 JOIN (SELECt from_id, MAX(timestamp) timestamp FROM messages GROUP BY from_id) t2 ON t1.from_id = t2.from_id AND t1.timestamp = t2.timestamp;
![如何使用GROUP BY获取每个组中的最新记录？[重复]](http://www.mshxw.com/aiimages/31/421105.png "如何使用GROUP BY获取每个组中的最新记录？[重复]")
您应该找出
timestamp每个组（子查询）中的最后一个值，然后将此子查询加入到表中-
SELECt t1.* FROM messages t1 JOIN (SELECt from_id, MAX(timestamp) timestamp FROM messages GROUP BY from_id) t2 ON t1.from_id = t2.from_id AND t1.timestamp = t2.timestamp;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
