-- mysql删除同表重复记录保存id最小的记录
delete from team where id in(
select a.id from(
select * from team where id not in
(select id from team group by n HAVING 1=1 order by id)
) a
)
mysql删除同表重复记录保存id最小的记录
最新推荐文章于 2019-03-13 16:04:19 发布
-- mysql删除同表重复记录保存id最小的记录
delete from team where id in(
select a.id from(
select * from team where id not in
(select id from team group by n HAVING 1=1 order by id)
) a
)