删除重复的数据 雨

delete from companyepe
where companyno  in (select  companyno  from companyepe  group  by  companyno   having  count(companyno) > 1)
and companyid not in (select min(companyid) from  companyepe  group by companyno  having count(companyno )>1)

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/manage/p/2482726.html