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.
MINUS

B.
INTERSECT

C.
UNION

D.
UNION ALL



Leave a Reply 1

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


Najaf

Najaf

Why UNION is not correct?