1、去掉重复记录 保留一条 DELETE FROM A_TEST WHERE UNAME IN ( SELECT UNAME FROM A_TEST GROUP BY UNAME HAVING COUNT(UNAME) > 1 ) AND ROWID NOT IN ( SELECT MIN(ROWID) FROM A_TEST GROUP BY UNAME HAVING COUNT(UNAME) > 1 )