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