SELECT * FROM tbl_person WHERE ID IN (SELECT max(ID) FROM tbl_person GROUP BY name)
MySQL去重字段后查询所有信息
最新推荐文章于 2023-09-12 08:40:07 发布
SELECT * FROM tbl_person WHERE ID IN (SELECT max(ID) FROM tbl_person GROUP BY name)