删除完全重复和部分关键字段重复的记录

源代码网整理以下以下为引用的内容：
Mysql

源代码网整理以下create table tmp select distinct * from tableName;

源代码网整理以下drop table tableName;

源代码网整理以下create table tableName select * from tmp;

源代码网整理以下drop table tmp;

源代码网整理以下以下为引用的内容：
alter table tableName add autoID int auto_increment not null;

源代码网整理以下create table tmp select min(autoID) as autoID from tableName group by Name,Address;

源代码网整理以下create table tmp2 select tableName.* from tableName,tmp where tableName.autoID = tmp.autoID;

源代码网整理以下drop table tableName;

源代码网整理以下rename table tmp2 to tableName;

源代码网整理以下SQL Server

源代码网整理以下select identity(int,1,1) as autoID, * into #Tmp from tableName;

源代码网整理以下select min(autoID) as autoID into #Tmp2 from #Tmp group by Name,Address;

源代码网整理以下drop table tableName;

源代码网整理以下select * into tableName from #Tmp where autoID in(select autoID from #Tmp2);

源代码网整理以下drop table #Tmp;

源代码网整理以下drop table #Tmp2;

源代码网整理以下Oracle

源代码网整理以下DELETE FROM tableName t1 WHERE t1.ROWID > (SELECT MIN(t2.ROWID) FROM tableName t2 WHERE t2.Name = t1.Name and t2.Address = t1.Address);