SQL · Joins and set operations

intersect

Rows present in both result sets.

sqlRunnable example sql course

Syntax

select … intersect select …

Example

Open in the lab

SELECT 'HTML' AS title INTERSECT SELECT 'HTML';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.