sql 面试题

删除表A中name字段重复的内容大于3次的。

sql：delete from A where name in(select name from A group by name having COUNT(name)>3)