--P_CODE 重复列DELETE FROM TabWHERE P_CODE IN(SELECT P_CODE FROM Tab GROUP BY P_CODE HAVING COUNT(P_CODE) > 1)AND ROWID NOT IN(SELECT MIN(ROWID) FROM Tab GROUP BY P_CODE HAVING COUNT(*) > 1);