CREATE TABLE emp_test2 (
       emp_no    INT         NOT NULL,
       emp_name  VARCHAR(30) NOT NULL,
       hire_date DATE            NULL,
       salary    INT             NULL,
       PRIMARY KEY (emp_no)
);

INSERT INTO emp_test2 (emp_no, emp_name, hire_date, salary)
SELECT emp_no, emp_name, hire_date, salary
  FROM emp_test
 WHERE emp_no IN (1001, 1002);

SELECT *
  FROM emp_test2;