这有效，请尝试：
DELETe Customer_SCDOUTPUT deleted.*FROM Customer_SCD bJOIN ( SELECt MIN(a.Customer_TimeStamp) Customer_TimeStamp, Customer_ID, Customer_Name FROM Customer_SCD a GROUP BY a.Customer_ID, a.Customer_Name) c ON c.Customer_ID = b.Customer_IDAND c.Customer_Name = b.Customer_NameAND c.Customer_TimeStamp <> b.Customer_TimeStamp
在子查询中，它确定哪个记录是每个的第一个记录
Customer_Name，
Customer_ID然后删除所有其他记录以作重复。我还添加了该
OUTPUT子句，该子句返回受该语句影响的行。
您也可以通过使用排名功能来做到这一点
ROW_NUMBER：
DELETe Customer_SCDOUTPUT deleted.*FROM Customer_SCD bJOIN ( SELECt Customer_ID, Customer_Name, Customer_TimeStamp, ROW_NUMBER() OVER (PARTITION BY Customer_ID, Customer_Name ORDER BY Customer_TimeStamp) num FROM Customer_SCD) c ON c.Customer_ID = b.Customer_IDAND c.Customer_Name = b.Customer_NameAND c.Customer_TimeStamp = b.Customer_TimeStampAND c.num <> 1
看看哪一个查询开销较小并使用它，当我检查它时，第一种方法效率更高（它具有更好的执行计划）。
这是一个 SQL小提琴
