sql 怎么去除重复的数据

Question

这个题看了大半天，感觉有点木有头绪，求大神指教啊！！！

Answer 1

delete from B where id not in (select MIN(id) from B group by name,aid)