一条sql语句,删除重复数据 创建一个表,添加数据 删除语句 DELETE FROM we WHERE id NOT IN(SELECT a.id FROM(SELECT id FROM we GROUP BY NAME,PASSWORD)a); 查询表 SELECT * FROM we; 完美删除重复数据,只保留一条