What is Intersect Operator in SQL Server - SQL Server Tutorial / TSQL Tutorial
The Intersect Operator returns us distinct matching records from two or more Select queries ( Result Sets).
For Intersect Operator to work, the Number of columns should be same in all Select queries and data type should match.
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/wh...