delete from table1 where [id] not in(select min([id]) from table1 group by field1,field2)delete from table1 where [id] not in(select min([id]) from table1 group by field1,field2)转载于:https://www.cnblogs.com/catxp/archive/2006/04/21/381787.html
删除重复的记录(SQL语句)
本文介绍了一种使用 SQL 语句从表 table1 中删除除每组最小 id 外的所有重复记录的方法。通过 group by 语句结合子查询实现，确保每个 field1 和 field2 组合只保留一个具有最小 id 的记录。
delete from table1 where [id] not in(select min([id]) from table1 group by field1,field2)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
