sql中如何删除一个表中重复的记录? 删除表中多余的重复记录

My sql 中删除表中重复记录？只保留一条 DELETE from user where id in(select id from user GROUP BY id HAVING COUNT(*)>；1)tablename自己211...