Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Set Operations


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;
Community Forums
Get help and ask questions in the Codecademy Forums
Report a Bug
If you see a bug or any other issue with this page, please report it here.