Summary: in this tutorial, you will learn how to use the SQL Server INTERSECT operator to combine result sets of two input queries and return the distinct rows that appear in both inputs.
Introduction to SQL Server INTERSECT #
The SQL Server INTERSECT combines result sets of two or more queries and returns distinct rows that are output by both queries.
The following illustrates the syntax of the SQL Server INTERSECT:
query_1
INTERSECT
query_2
Code language: SQL (Structured Query Language) (sql)Similar to the UNION operator, the queries in the syntax above must conform to the following rules:
- Both queries must have the same number and order of columns.
- The data type of the corresponding columns must be the same or compatible.