EXCEPT is constructed in the same way, but returns distinct rows from the first SELECT statement that aren’t output by the second SELECT statement.

SELECT column_name(s) FROM table1

EXCEPT

SELECT column_name(s) FROM table2;

Suppose we want to see if there are any categories that are in the new_products table that aren’t in the legacy_products table. We can use an EXCEPT query to perform this analysis:

SELECT category FROM new_products

EXCEPT

SELECT category FROM legacy_products;