去重

delete from hero where id not in(select * from ( select min(id) from hero group by name) as temp);

posted @ 2018-12-09 10:27  damon11  阅读(72)  评论(0)    收藏  举报