sql server 删除某字段重复记录

delete from ArticleCategoryLabel where id not in ( select min(id)  from ArticleCategoryLabel group by name )