Answer:
Intersect
Explanation:
Intersect is useful when we want to get common elements from two collections. When we go for sql server this query operator is used to select the common records in both tables based on some condition.
the syntax for this in sql server is as shown below
SELECT expression1, expression2, ... expression
FROM tables
[WHERE conditions]
INTERSECT
SELECT expression1, expression2, ... expression
FROM tables
[WHERE conditions];
