随笔 - 13, 文章 - 0, 评论 - 1, 阅读 - 6579

删除重复的数据

Posted on   雨-夜  阅读(166)  评论(0编辑  收藏  举报

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)

努力加载评论中...
点击右上角即可分享
微信分享提示