INTERSECT

A set operation returning distinct rows present in both query results.

What is INTERSECT in a relational database?

INTERSECT — A set operation returning distinct rows present in both query results.

SELECT email FROM customer
INTERSECT
SELECT email FROM subscriber;

Level: Apprentice · More Database terms at this level

Updated