Which SET operator should be used in the blank space in the following SQL statement to display the cities that have departments located in them?

View the Exhibit and examine the structure of the LOCATIONS and DEPARTMENTS tables.

Which SET operator should be used in the blank space in the following SQL statement to display
the cities that have departments located in them?
SELECT location_id, city
FROM locations
SELECT location_id, city
FROM locations JOIN departments
USING(location_id);

View the Exhibit and examine the structure of the LOCATIONS and DEPARTMENTS tables.

Which SET operator should be used in the blank space in the following SQL statement to display
the cities that have departments located in them?
SELECT location_id, city
FROM locations
SELECT location_id, city
FROM locations JOIN departments
USING(location_id);

A.
UNION

B.
MINUS

C.
INTERSECT

D.
UNION ALL



Leave a Reply 0

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