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