SQL 删除属性重复的记录

DELETE FROM TableAWHERE sid in (SELECT sidFROM TableA as A, (select  sname , min(sid) ID_min from tableA group by sname having count(sname)>1 ) as BWHERE A.sname=B.sname and A.sid !=B.ID_min) ;