摘要：--查找表中多余的重复记录select * from code_xz where code in (select code from code_xz group by code having count(1)>1) --删除表中多余的重复记录，只留有pk_uid最小的记录delete from co 阅读全文