INTERSECT, EXCEPT Operators in SQL Server
Click here to Subscribe to IT PORT Channel : / @itport28
INTERSECT operator returns all distinct rows from Left hand side table which does exist in Right hand side table
EXCEPT operator returns all distinct rows from left hand side table which does not exist in right hand side table
The Basic Rules for using these Operators are
a) The Number and the Order of the columns must be the same in all queries
b) The data type must be compatible