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