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.SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]
INTERSECT
SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]INTERSECT:
BASICALLY INTERSECT COMBINES COMMON
ELEMENTS OF BOTH TABLESThe 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.SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]
INTERSECT
SELECT column1 [, column2 ]
FROM table1 [, table2 ]
[WHERE condition]INTERSECT:
BASICALLY INTERSECT COMBINES COMMON
ELEMENTS OF BOTH TABLES