Skip
Arish's avatar

207. INTERSECT

INTERSECT

Returns common rows in both queries.

sql
1SELECT course FROM students
2INTERSECT
3SELECT course FROM teachers;

Only courses in both tables.