单选题
Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 EMP HIST EMPLOYEE_ID NAME JOB_ID SALARY 101 Smith SA_CLERK 2000 103 Chris IT_CLERK 2200 104 John HR_CLERK 2000 106 Smith AD_ASST 3000 108 Jennifer HR_MGR 4500 The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table. Which statement accomplishes this task?（）
发布日期：2020-04-10
UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);
MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name, job id, e.salary);
MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);
MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employees_id, e.name, e.job_id, e.salary);
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
右心衰竭所致肝大和水肿与肝硬化所致者最主要的鉴别点是（）
股票的账面价值又称股票净值或每股净资产，是指（）。
下列（）不是曲轴连杆机构的零件。
如果避灾地点没有新鲜空气，或者有害气体大量涌出，必须立即佩戴自救器。
目前认为蓝光效应是光受体是（）
T6人事10.3中，下列不属于报表管理中预置的报表项目为（）。
三字点由（）组成。
认为人的心理与生理、精神与躯体、机体内外环境是一个完整的统一体属于（）。
下列我国目前的房地产权利中属于物权的有（）。
砂石桩法包括下列（）。
暂无相关推荐~
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is ...
Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_I...
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary k...
Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL s...
Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DE...
Examine the data in the EMPLOYEES and EMP_HIST tables: EMPLOYEES NAME DEPT_ID MG...
Exhibit Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to re...
Examine the data in the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMP_NAME DEP...