select * from His_4251022 group by ID having count(*)>1;
delete from His_4251022 where His_4251022.rowid not in (select MAX(His_4251022.rowid) from His_4251022 group by ID);
select * from His_4251022 group by ID having count(*)>1;
delete from His_4251022 where His_4251022.rowid not in (select MAX(His_4251022.rowid) from His_4251022 group by ID);
本文标题:2023-02-17 删除重复数据
本文链接:https://www.haomeiwen.com/subject/lerpkdtx.html
网友评论