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
Learn

Congratulations! We just learned about Set Operations in SQL. What can we generalize so far?

  • The UNION clause allows us to utilize information from multiple tables in our queries.
  • The UNION ALL clause allows us to utilize information from multiple tables in our queries, including duplicate values.
  • INTERSECT is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
  • EXCEPT returns distinct rows from the first SELECT statement that aren’t output by the second SELECT statement
Report a Bug
If you see a bug or any other issue with this page, please report it here.