What is intersect in sql

This article is tagged with: What is intersect in sql and mysql

what is intersect in sql

The SQL INTERSECT clause/operator is used to combine two SELECT statements,
but returns rows only from the first SELECT statement
that are identical to a row in the second SELECT statement.
This means INTERSECT returns only common rows returned by the two
SELECT statements.

This article is tagged with: What is intersect in sql and mysql