核心提示:d elete FROM [old].[dbo].[pro]W HERE 1=1 A ND tit i n (S ELECT * F ROM ( (S ELECT tit FROM [old].[db...
d elete FROM [old].[dbo].[pro]
W HERE 1=1
A ND tit i n (S ELECT * F ROM ( (S ELECT tit FROM [old].[dbo].[pro] GROUP BY tit H AVING C OUNT(tit)>1) ) a)
A ND ID not i n (S ELECT * F ROM ( (S ELECT M IN(ID) ids F ROM [old].[dbo].[pro] G ROUP BY tit H AVING C OUNT(tit)>1) ) b)





