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...
On this page of the site you can watch the video online What is Intersect Operator in SQL Server - SQL Server Tutorial / TSQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 06 April 2015, share the link with friends and acquaintances, this video has already been watched 1,552 times on youtube and it was liked by 1 viewers. Enjoy your viewing!