Prev Question
Next Question

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

The query should display the employee IDs of all the employees who have held the job SA_MAN at any time during their tenure.

Choose the correct SET operator to fill in the blank space and complete the following query.

SELECT employee_id
FROM employees
WHERE job_id = ‘SA_MAN’
____________ SELECT employee_id
FROM job_history
WHERE job_id=’SA_MAN’;

A.
UNION

B.
MINUS

C.
INTERSECT

D.
UNION ALL

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *