导航

删除重复的数据

Posted on 2012-05-04 15:01  雨-夜  阅读(171)  评论(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)