what is intersect in ms sql?

Jul 8 2017 1:50 AM

INTERSECT returns distinct rows that are output by both the left and right input queries operator.

The number and order of the columns must be same in all queries.