删除相同数据

--1
DELETE FROM TEST010 T
 WHERE T.ROWID IN (SELECT A.ROWID
                     FROM TEST010 A
                     JOIN TEST010 B ON A.F1 = B.F1
                                   AND A.ROWID > B.ROWID)
;

--2
DELETE FROM test1 a
 WHERE ROWID <> (SELECT MAX(ROWID)
                   FROM test1 b
                  WHERE a.id = b,ID
                )
;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24805255/viewspace-721225/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24805255/viewspace-721225/