Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor

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;
Report a Bug
If you see a bug or any other issue with this page, please report it here.