select group_id, max(time) as time from table group by group_id;
[quote=引用 1 楼 hnyxwl_liufan 的回复:] SELECT a.id, a.group_id, a.time FROM table a WHERE a.time= ( SELECT max(time) FROM table WHERE a.group_id= group_id)
SELECT a.id, a.group_id, a.time FROM table a WHERE a.time= ( SELECT max(time) FROM table WHERE a.group_id= group_id)
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧