——————————>
需得到以上效果,mysql语句如下:
delete from Users where id in (
select a.id from (
select max(id) id from Users a where EXISTS(
select 1 from Users b where a.name=b.name group by name HAVING count(1)>1
)
group by name
) a
)