SELECT * from
(SELECT * from student where 1=1
and user_id='111111'
and c_user_id !='111111' ORDER BY create_time desc LIMIT 1000) as stu
GROUP BY stu.tent_id ORDER BY stu.create_time desc
mysql单表分组查询每组 中最新时间的记录
最新推荐文章于 2024-06-14 13:13:00 发布