103. View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY
tables.The EMPLOYEES table maintains the most recent information regarding
salary, department, and job for all the employees. The JOB_HISTORY table
maintains the record for all the job changes for the employees. You want to
delete all the records from the JOB_HISTORY table that are repeated in the
EMPLOYEES table. Which two SQL statements can you execute to accomplish the
task? (Choose two.)
A. DELETE FROM job_history j
WHERE employee_id =(SELECT employee_id
FROM employees e WHERE j.employee_id = e.employee_id)
AND job_id = (SELECT job_id FROM employees e
WHERE j.job_id = e.job_id);
B. DELETE FROM job_history j
WHERE (employee_id, job_id) = ALL
(SELECT employee_id, job_id FROM employees e WHERE j.employee_id =
e.employee_id and j.job_id = e.job_id )
C. DELETE FROM job_history j WHERE employee_id =(SELECT employee_id
FROM employees e WHERE j.employee_id = e.employee_id and j.job_id =
e.job_id )
D. DELETE FROM job_history j
WHERE (employee_id, job_id) = (SELECT employee_id, job_id
FROM employees e WHERE j.employee_id = e.employee_id and j.job_id =
e.job_id )
Answer: CD
C,D是同一个意思，而A把删除范围扩大了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718910/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
