删除数据库中表的某些相同的某些记录 OR 查找数据库的表中的相同记录

 

一、删除数据库中表的某些相同的某些记录

delete from tablename where only_Id not in(select min(only_id) from tablename group by sameName)

二、选出相同记录的SQL语句 AND 删除相同记录的SQL语句删除相同记录的SQL语句

//IF 表中无主键，ID中无（IDENTITY(1,1)）,ID相同的记录删除？

a、select * from tableName where id in(select id from tableName group by id having count(*) >1)

 b、delete from tableName where id in(select id from talbeName group by id having count(*) >1)