删除两个数据库中的重复记录

Question

我设法从两个不同的数据库中识别重复记录：

select * from 
    taskperformance a,  taskperformance@dm_prod b
where 
    a.activityin = b.activityin
    and a.completiondate = b.completiondate

如何从 b 中删除重复记录？

我尝试过：

delete taskperformance@dm_prod  where exist ( 
select * from 
    taskperformance a,  taskperformance@dm_prod b
where 
    a.activityin = b.activityin
    and a.completiondate = b.completiondate ) 

但它删除的内容超出了我需要的内容。

Answer 1

您不应在子查询中重新引用 b：

delete taskperformance@dm_prod b
where exists (
    select * from taskperformance a
    where a.activityin = b.activityin 
    and a.completiondate = b.completiondate 
)