oracle表数据去重 DELETE SG_MOGOIMG_WSC A WHERE NOT EXISTS (SELECT 1 FROM (SELECT FILEID, MAX(ROWID) MAXROWID FROM SG_MOGOIMG_WSC GROUP BY FILEID) T WHERE A.ROWID = T.MAXROWID);