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.