select * from members m where m.id in
(select SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY age desc),',',1) from members
GROUP BY username
ORDER BY age desc
) ORDER BY m.age desc
分组后取每组最新的数据
最新推荐文章于 2024-05-14 17:15:27 发布
select * from members m where m.id in
(select SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY age desc),',',1) from members
GROUP BY username
ORDER BY age desc
) ORDER BY m.age desc