bud

摘要： 1.根据名称分组去重，并查询记录ID select max(id) from T_TABLE GROUP BY name 2.根据ID获取记录 select * from T_TABLE where ID in ( select max(id) from T_TABLE GROUP BY name 阅读全文