delete from 表 where id not in  
(select max(id) from 表 group by mobilePhone,officePhone,email )  
or 
delete from 表 where id not in  
 (select min(id) from 表 group by mobilePhone,officePhone,email ) 

delete from 表 where id not in 
(select max(id) from 表 group by mobilePhone,officePhone,email ) 
or 
delete from 表 where id not in 
 (select min(id) from 表 group by mobilePhone,officePhone,email ) 

//查詢出唯一數(shù)據(jù)的ID,并把他們導(dǎo)入臨時(shí)表tmp中  
select min(id) as mid into tmp from 表 group by mobilePhone,officePhone,email  
 //查詢出去重后的數(shù)據(jù)并插入finally表中  
insert into finally select (除ID以外的字段) from customers_1 where id in (select mid from tmp) 

//查詢出唯一數(shù)據(jù)的ID,并把他們導(dǎo)入臨時(shí)表tmp中 
select min(id) as mid into tmp from 表 group by mobilePhone,officePhone,email 
 //查詢出去重后的數(shù)據(jù)并插入finally表中 
insert into finally select (除ID以外的字段) from customers_1 where id in (select mid from tmp) 

delete tmp from(  
select row_num = row_number() over(partition by 字段，字段 order by 時(shí)間 desc)  
 from 表 where 時(shí)間> getdate()-1  
 ) tmp  
 where row_num > 1 
delete tmp from( 
select row_num = row_number() over(partition by 字段，字段 order by 時(shí)間 desc) 
 from 表 where 時(shí)間> getdate()-1 
 ) tmp 
 where row_num > 1 

delete from 表 where 主鍵ID not in(  
select max(主鍵ID) from 表 group by 需要去重的字段 having count(需要去重的字段)>=1  
 ) 
delete from 表 where 主鍵ID not in( 
select max(主鍵ID) from 表 group by 需要去重的字段 having count(需要去重的字段)>=1 
 ) 

delete top(2) from 表  
   where not exists (select 主鍵ID  
 from #tmp where #tmp.主鍵ID=表.主鍵ID)