What are the INTERSECT Operators in SQL Server ?

INTERSECT operator in SQL Server is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost the same results as the INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible.



You May Interest

What is Blocking in SQL Server ?

What are the Various Limitations of the Views in SQL Server ?

MS SQL Restoring a Database With a Query

What is Utility Control Point (UCP) in SQL Server ?

What is an OUTPUT Clause Inside SQL Server ?