--重复记录查询

--重复记录查询
delete from [SRPProdDynamic] where ID not in(select min(ID) from [SRPProdDynamic] group by [well_name] )

原文地址:https://www.cnblogs.com/cinemaparadiso/p/12765639.html