表 t_user_info
id groupid content lasttime
select * from t_user_info t where not exists
(select * from t_user_info where groupid= t.groupid and t.lasttime<lasttime)
表 t_user_info
id groupid content lasttime
select * from t_user_info t where not exists
(select * from t_user_info where groupid= t.groupid and t.lasttime<lasttime)
转载于:https://www.cnblogs.com/isawu/p/10916786.html