Sky_True的博客

日志框架基本使用

总结：先组内max排序得到字段最大值，再按排序字段(date)排序整个表: select a.*,b.* from chat_record as a RIGHT JOIN (select user_id,to_id,max(date) as date FROM chat_record GROUP BY user_id,to_id) as b on a.user_id=b.user_id and a.to_id=b.to_id and a.date = b.date GROUP BY a.user_id,a