what is intersect in ms sql?

Question

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.

Manikandan Murugesan · Answer

The SQL Server ( Transact - SQL ) INTERSECT operator is used to return the records that are in common between two SELECT statements or data sets. If a record exists in one query and not in the other it will be omitted from the INTERSECT results. It is the intersection of the two SELECT statements. Refer the following Link : https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql#syntax