剔除表emp1的重复数据:
DELETE FROM EMP1
WHERE EMPNO IN(SELECT EMPNO
FROM EMP1
GROUP BY EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
HAVING COUNT(1) > 1)
AND ROWID NOT IN
(SELECT MIN(ROWID)
FROM EMP1
GROUP BY EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
HAVING COUNT(1) > 1)