INTERSECT vs EXCEPT, EXCEPT vs MINUS, INTERSECT vs IN, EXCEPT vs NOT IN, INTERSECT vs JOIN

INTERSECT vs EXEPT, EXCEPT vs MINUS, INTERSECT vs IN, EXCEPT vs NOT IN, INTERSECT vs JOIN, EXCEPT vs JOIN Agenda: Q01. INTERSECT vs JOIN in SQL Q02. INTERSECT vs IN clause in SQL Q03. INTERSECT vs JOIN in SQL Q04. EXCEPT vs NOT IN in SQL (MINUS vs IN) Q05. EXCEPT vs JOIN in SQL (MINUS vs JOIN) Q06. UNION vs IN clause in SQL Q07. UNION vs JOIN in SQL INTERSECT: Returns only those rows which are common to both of the SELECT statements.