mysql取分组数据中每个分组的最新一条数据
select * from data td,(select max(id) id from log group by name) md where td.id = md.id
mysql取分组数据中每个分组的最新一条数据
最新推荐文章于 2024-09-19 06:04:45 发布
mysql取分组数据中每个分组的最新一条数据
select * from data td,(select max(id) id from log group by name) md where td.id = md.id