给你一个sql。查询某字段相同的记录
select INITIALS , CUST_MP , VIN , count(*) from tblcustomer where category_flag='C' group by INITIALS , CUST_MP , VIN having count(*)>1 order by initials
然后再做删除的动作吧
我搞不懂你要删除的流程是什么就不帮你写了
select distinct * from into newtablename from oldtablename
delete from oldtablelname
select * into oldtablename from newtablename
delete from newtablename