摘要:
DELETE FROM T_USER; INSERT INTO T_USER SELECT * FROM T_USER AS OF TIMESTAMP TO_TIMESTAMP('2021-01-19 09:06:00', 'yyyy-mm-dd HH24:mi:ss')--回滚到某个时间 COMM 阅读全文
摘要:
DELETE FROM TABLE_NAME A WHERE (A.FIELD1, A.FIELD2) IN (SELECT FIELD1, FIELD2 FROM TABLE_NAME GROUP BY FIELD1, FIELD2 HAVING COUNT(*) > 1) AND ROWID N 阅读全文