一、删除数据库中表的某些相同的某些记录
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)