问：如何查询重复数据？
select name,sex,count(*) from test group by name,sex HAVING count(*)>1。
问：如何删除重复数据并保留ID最大的数据？
delete a from test a join
(select name,sex,count(*) ,max(id) as id
from test group by name,sex
HAVING count(*)>1) b on a.name=b.name where a.id<b.id
mysql如何删除重复数据并保留ID最大的数据
标签：16px having group by name join style rom test from