如果一张表中存在数据重复,如何快速高效去重?
通过rowid去重效率最高,demo如下:
EMPLOYEE_ID 为去重后唯一关键字
DELETE FROM SCOTT.F_EMPLOYEE
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM ISCOTT.F_EMPLOYEE
group by EMPLOYEE_ID);
如果一张表中存在数据重复,如何快速高效去重?
通过rowid去重效率最高,demo如下:
EMPLOYEE_ID 为去重后唯一关键字
DELETE FROM SCOTT.F_EMPLOYEE
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM ISCOTT.F_EMPLOYEE
group by EMPLOYEE_ID);