INTERSECT

Take rows common to two queries.

INTERSECT returns the intersection of two SELECT results. Rows found in both queries are returned.

SELECT name FROM customers
INTERSECT
SELECT name FROM leads;

This query returns those who are both customers and leads.

name is selected from customers.

INTERSECT — details

INTERSECT keeps only rows present in both sets. Duplicates are automatically removed.

For example, to find companies that are both customers and suppliers, you intersect the two lists with INTERSECT.

Find those who are both customers and leads using INTERSECT.

Show example solution

SELECT name FROM customers
INTERSECT
SELECT name FROM leads;

Add INTERSECT

SELECT name FROM customers
____
SELECT name FROM leads;

Show answer

SELECT name FROM customers
INTERSECT
SELECT name FROM leads;

Next lesson: EXCEPT