Home Forums SQL Server 2014 Development - SQL Server 2014 In a self-joined table, how to remove ALL records with duplicates RE: In a self-joined table, how to remove ALL records with duplicates
vujicikm
SSC Veteran
Points: 201
More actions
April 24, 2018 at 9:48 pm
#1988140
Another condition here is that assuming that the Col3 of rows 1 and 2 are the same, they must not be deleted because the ID and the ORIGIDof those records are not equal. Can anyone help? Thank you