2013年11月27日
SQL 删除重复的数据（多个字段判断），只保留一条数据
摘要： delete from tblBuyerMsg where (buyerinfo) in (select buyerinfo from tblBuyerMsg group by buyerinfo having count(*) > 1)AND buyername in (select buyername from tblBuyerMsg group by buyername having count(*)>1)AnD address in (select address from tblBuyerMsg group by address having count(*)>1) 阅读全文
posted @ 2013-11-27 10:35 JasonGu0 阅读(575) 评论(1) 推荐(0)