Expected Results EMPHIREDATE 2000-11-08 JOB-CODE 502 EMP-INITIAL EMPFNAME John D

Question

Expected Results EMPHIREDATE 2000-11-08 JOB-CODE 502 EMP-INITIAL EMPFNAME John David EMPLNAME EMP,NUM 101 102 News 1989-07-12 501 or Actual Results EMP NUM EMP LNAMEEMP FNAME EMP INITIAL EMP HIREDATE JOB CODE 101 102 News John 2000-11-08 502 Senior David 1989-07-12 501 Problem 3 using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EPPLovef table into the ap" table Remember your subquery should only retrieve the columns needed for the ERPa table and only the employees shown in the figure compne Problem 3 above

Explanation / Answer

INSERT INTO Emp_1 (EMP_NUM,EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_HIREDATE,JOB_CODE,EMP_YEARS) SELECT EMP_NUM,EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_HIREDATE,JOB_CODE,EMP_YEARS FROM EMPLOYEE WHERE EMP_NUM>102;

This is how we can copy the rows from one table to another. In the 'WHERE' condition, we are giving 'EMP_NUM>102' to filter the first two rows as they are already in the EMP_1 table. I think this query will work. Thanks

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.