SQL INTERSECT

The SQL INTERSECT query is similar to the SQL UNION query, also works on two SQL Select statements. The difference is that SQL UNION query selects rows either in the first or the second Select statement (like OR operator), while the SQL INTERSECT query selects rows in the both first and second Select statement (like AND operator).

Note: SQL INTERSECT query only returns distinct values.

SQL INTERSECT Query Syntax

SELECT Column(s) FROM Table1
INTERSECT
SELECT Column(s) FROM Table2

SQL INTERSECT Query Example

Table: FinanceEmployees

Table: DevelopmentEmployees

Select all the employees in both FinanceEmployees and DevelopmentEmployees:

SELECT EmployeeId, FirstName, LastName FROM FinanceEmployees 
INTERSECT
SELECT EmployeeId, FirstName, LastName FROM DevelopmentEmployees

The result will look like: