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)