INTERSECT Clause
The INTERSECT clause takes the results of two SELECT statements and returns only rows that appear in both result tables. INTERSECT removes duplicate rows from the final result table. INTERSECT does not support the ALL option.
The following example returns all rows from the employee table where salary is between 75000 and 100000:
SELECT * FROM employee WHERE salary >= 75000
INTERSECT
SELECT * FROM employee WHERE salary <= 100000;