Delete from TempA where id not in ( select max(t1.id) from TempA t1 group by t1.PositionName,t1.EnglishPositionName)
group by后面跟重复的字段