Code如下:
DELETE FROM DAT_PART B WHERE B.ROWID >
(SELECT MIN(A.ROWID) FROM DAT_PART A WHERE A.PART_ID=B.PART_ID);
刪除DAT_PART表中的PART_ID為相同的值,并保留PART_ID成為唯一值.
Code如下:
DELETE FROM DAT_PART B WHERE B.ROWID >
(SELECT MIN(A.ROWID) FROM DAT_PART A WHERE A.PART_ID=B.PART_ID);
刪除DAT_PART表中的PART_ID為相同的值,并保留PART_ID成為唯一值.