Intersect intersection operation

The Intersect intersection is a set composed of all elements of both set a and Set B, such as 1.

The Intersect distinct set operation logically first deletes duplicate rows from two input multiple sets, converts multiple sets to a set, and then returns rows that only appear in both sets. Simply put, if a row appears at least once in both input and multiple sets, the result returned by the intersection will contain this row.

The following is a simple example.

Use tsqlfundamentals2008; go -- intersect distinct, delete duplicate rows select country, region, city from HR. employeesintersectselect country, region, city from sales. MERs MERS;

The query result is as follows:

 

Intersect intersection operation