SQL Statements › INSERT › Example 3

Example 3

Load the temporary table TEMPEMP with data from Department E1 from EMP.

      INSERT INTO SMITH.TEMPEMP
           SELECT *
           FROM EMP
           WHERE WORKDEPT = 'E1'