Oracle_删除除了指定的主键值外的其他数据

Oracle      删除除了指定的主键值外的其他数据

 

DELETE FROM EMP E
 WHERE E.EMPNO NOT IN (SELECT EMPNO
          FROM EMP
         WHERE EMPNO = 7369
            OR EMPNO = 7499
            OR EMPNO = 7521
            OR EMPNO = 7566
            OR EMPNO = 7654
            OR EMPNO = 7698
            OR EMPNO = 7782
            OR EMPNO = 7788
            OR EMPNO = 7839
            OR EMPNO = 7844
            OR EMPNO = 7876
            OR EMPNO = 7900
            OR EMPNO = 7902
            OR EMPNO = 7934);