SELECT
a.*
FROM
[table_name] a
WHERE
id = ( SELECT id FROM [table_name] WHERE [分组字段] = a.[分组字段] ORDER BY a.create_time desc LIMIT 1 )
and id in (xxx);
mysql分组查询组内最新数据新写法
最新推荐文章于 2023-11-16 18:38:13 发布
SELECT
a.*
FROM
[table_name] a
WHERE
id = ( SELECT id FROM [table_name] WHERE [分组字段] = a.[分组字段] ORDER BY a.create_time desc LIMIT 1 )
and id in (xxx);