Which of the following standard query operator returns the common elements from two collections? distinct except intersect union expression tree is i

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];